[Home] [Help]
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;
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,
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:
1114: ap_expense_report_lines aerl,
1115: ap_exp_report_dists dist,
1116: ap_system_parameters s,
1117: fnd_currencies_vl c,
1118: gl_sets_of_books sob,
1119: ap_expense_report_params erp
1120: WHERE c.currency_code = s.base_currency_code
1121: AND sob.set_of_books_id = s.set_of_books_id
1122: AND erp.parameter_id = p_exp_type_parameter_id
1486: FROM ap_expense_report_headers_all aerh,
1487: ap_expense_report_lines_all aerl,
1488: ap_system_parameters_all s,
1489: fnd_currencies_vl c,
1490: gl_sets_of_books sob,
1491: ap_expense_report_params_all erp
1492: WHERE c.currency_code = s.base_currency_code
1493: AND sob.set_of_books_id = s.set_of_books_id
1494: AND erp.parameter_id = p_web_parameter_id