APPS.AP_WEB_ACCTG_PKG dependencies on GL_SETS_OF_BOOKS

Line 109: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;

105: p_maximum_size OUT NOCOPY NUMBER) IS
106:
107: l_debug_info varchar2(200);
108:
109: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
110: l_cost_center_seg_num NUMBER;
111: l_appcol_name fnd_id_flex_segments_vl.application_column_name%type;
112: l_seg_name fnd_id_flex_segments_vl.segment_name%type;
113: l_prompt fnd_id_flex_segments_vl.form_left_prompt%type;

Line 509: gl_sets_of_books GS

505: -- Query up the Chart of Accounts Id for the Employee
506: SELECT GS.chart_of_accounts_id
507: INTO l_chart_of_accounts_id
508: FROM ap_system_parameters S,
509: gl_sets_of_books GS
510: WHERE GS.set_of_books_id = S.set_of_books_id
511: AND rownum = 1;
512: -- Get the Column Name which implements the Cost Center Segment
513: IF ( FND_FLEX_APIS.GET_SEGMENT_COLUMN(101,

Line 561: p_chart_of_accounts_id IN GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE,

557: -- ALING 30-SEP-04 Created.
558: --
559: -------------------------------------------------------------------------
560: PROCEDURE GetDistributionSegments(
561: p_chart_of_accounts_id IN GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE,
562: p_report_distribution_id IN NUMBER,
563: p_segments OUT NOCOPY AP_OIE_KFF_SEGMENTS_T) IS
564: --------------------------------------------------------------------------------
565:

Line 1123: gl_sets_of_books sob,

1119: ap_expense_report_lines aerl,
1120: ap_exp_report_dists dist,
1121: ap_system_parameters s,
1122: fnd_currencies_vl c,
1123: gl_sets_of_books sob,
1124: ap_expense_report_params erp
1125: WHERE c.currency_code = s.base_currency_code
1126: AND sob.set_of_books_id = s.set_of_books_id
1127: AND erp.parameter_id = p_exp_type_parameter_id

Line 1497: gl_sets_of_books sob,

1493: FROM ap_expense_report_headers_all aerh,
1494: ap_expense_report_lines_all aerl,
1495: ap_system_parameters_all s,
1496: fnd_currencies_vl c,
1497: gl_sets_of_books sob,
1498: ap_expense_report_params_all erp
1499: WHERE c.currency_code = s.base_currency_code
1500: AND sob.set_of_books_id = s.set_of_books_id
1501: AND erp.parameter_id = p_web_parameter_id

Line 1732: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;

1728: PROCEDURE GetDependentSegmentValue(p_employee_id IN NUMBER,
1729: p_vset_name IN VARCHAR2,
1730: p_seg_value OUT NOCOPY VARCHAR2) IS
1731: l_EmpInfoRec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;
1732: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
1733: l_dep_seg_num NUMBER;
1734: l_segments FND_FLEX_EXT.SEGMENTARRAY;
1735: l_num_of_segments NUMBER;
1736: BEGIN