eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_DB_EXPDIST_PKG dependencies on AP_EXP_REPORT_DISTS

Line 36: FROM ap_exp_report_dists aerd

32: BEGIN
33:
34: SELECT code_combination_id
35: INTO l_line_ccid
36: FROM ap_exp_report_dists aerd
37: WHERE aerd.report_distribution_id = p_report_distribution_id
38: AND aerd.code_combination_id is not null;
39:
40: x_line_ccid := l_line_ccid;

Line 67: FROM ap_exp_report_dists rd

63: BEGIN
64:
65: SELECT 'Y'
66: INTO l_temp
67: FROM ap_exp_report_dists rd
68: WHERE rd.report_distribution_id = p_report_distribution_id;
69:
70: return TRUE;
71:

Line 90: UPDATE ap_exp_report_dists RD

86: p_exp_line_ccid IN expDist_CODE_COMBINATION_ID)
87: RETURN BOOLEAN IS
88: -----------------------------------------------------------------------------
89: BEGIN
90: UPDATE ap_exp_report_dists RD
91: SET RD.code_combination_id = p_exp_line_ccid
92: WHERE RD.report_header_id = p_report_header_id
93: AND RD.report_line_id = p_report_line_id;
94:

Line 116: UPDATE ap_exp_report_dists RD

112: ) RETURN BOOLEAN IS
113: --------------------------------------------------------------------------------
114: BEGIN
115:
116: UPDATE ap_exp_report_dists RD
117: SET RD.code_combination_id = p_exp_dist_ccid
118: WHERE RD.report_header_id = p_report_header_id
119: AND RD.report_distribution_id = p_report_distribution_id;
120:

Line 144: FROM AP_EXP_REPORT_DISTS

140: -- in the FOR UPDATE is missing and NOWAIT is used, so the OF
141: -- REPORT_HEADER_ID is used as a place holder.
142: CURSOR ReportDistributions IS
143: SELECT REPORT_HEADER_ID
144: FROM AP_EXP_REPORT_DISTS
145: WHERE (REPORT_HEADER_ID = P_ReportID)
146: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
147:
148: BEGIN

Line 159: DELETE AP_EXP_REPORT_DISTS WHERE CURRENT OF ReportDistributions;

155: FETCH ReportDistributions into l_TempReportHeaderID;
156: EXIT WHEN ReportDistributions%NOTFOUND;
157:
158: -- Delete matching line
159: DELETE AP_EXP_REPORT_DISTS WHERE CURRENT OF ReportDistributions;
160: END LOOP;
161:
162: CLOSE ReportDistributions;
163:

Line 199: FROM ap_exp_report_dists

195: Added rownum condition to avoid TOO_MANY_ROWS_RETURNED exception. */
196:
197: SELECT report_line_id
198: INTO l_has_dist
199: FROM ap_exp_report_dists
200: WHERE report_line_id = p_source_report_line_id
201: AND ROWNUM = 1;
202:
203:

Line 216: UPDATE AP_EXP_REPORT_DISTS

212:
213:
214: -- For the given line, move its distributions from original ER
215: -- to the new ER
216: UPDATE AP_EXP_REPORT_DISTS
217: SET report_header_id = p_target_report_header_id,
218: report_line_id = p_target_report_line_id
219: WHERE report_line_id = p_source_report_line_id;
220:

Line 250: INSERT INTO AP_EXP_REPORT_DISTS

246: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
247: 'start DuplicateDistributions');
248:
249: -- For the given line, duplicate its distributions
250: INSERT INTO AP_EXP_REPORT_DISTS
251: (
252: report_header_id,
253: report_line_id,
254: report_distribution_id,

Line 302: AP_EXP_REPORT_DISTS_S.NEXTVAL AS report_distribution_id,

298: )
299: SELECT
300: p_target_report_header_id AS report_header_id,
301: p_target_report_line_id AS report_line_id,
302: AP_EXP_REPORT_DISTS_S.NEXTVAL AS report_distribution_id,
303: org_id,
304: sequence_num,
305: SYSDATE AS last_update_date,
306: p_user_id AS last_updated_by,

Line 346: FROM AP_EXP_REPORT_DISTS

342: task_id,
343: award_id,
344: expenditure_organization_id,
345: cost_center
346: FROM AP_EXP_REPORT_DISTS
347: WHERE
348: report_line_id = p_source_report_line_id;
349:
350:

Line 391: FROM ap_exp_report_dists

387:
388: BEGIN
389: SELECT report_distribution_id
390: INTO l_report_distribution_id
391: FROM ap_exp_report_dists
392: WHERE report_header_id = p_report_header_id
393: AND report_line_id = p_report_line_id
394: AND rownum = 1;
395:

Line 406: UPDATE ap_exp_report_dists

402: END;
403:
404: end if;
405:
406: UPDATE ap_exp_report_dists
407: SET (code_combination_id,
408: segment1,
409: segment2,
410: segment3,

Line 508: FROM ap_exp_report_dists

504:
505: BEGIN
506: SELECT report_distribution_id
507: INTO l_report_distribution_id
508: FROM ap_exp_report_dists
509: WHERE report_header_id = p_report_header_id
510: AND report_line_id = p_report_line_id
511: AND rownum = 1;
512:

Line 523: UPDATE ap_exp_report_dists

519: END;
520:
521: end if;
522:
523: UPDATE ap_exp_report_dists
524: SET (code_combination_id,
525: segment1,
526: segment2,
527: segment3,

Line 604: FROM AP_EXP_REPORT_DISTS_ALL

600: IS
601: --------------------------------------------------------------------------------
602: CURSOR dist_lines_c IS
603: SELECT *
604: FROM AP_EXP_REPORT_DISTS_ALL
605: WHERE REPORT_HEADER_ID = p_report_header_id
606: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
607:
608: dist_lines_rec dist_lines_c%ROWTYPE;

Line 619: UPDATE ap_exp_report_dists_all

615: FETCH dist_lines_c into dist_lines_rec;
616: EXIT WHEN dist_lines_c%NOTFOUND;
617:
618: IF dist_lines_rec.CODE_COMBINATION_ID IS NOT NULL THEN
619: UPDATE ap_exp_report_dists_all
620: SET (segment1,
621: segment2,
622: segment3,
623: segment4,

Line 703: l_dist_id AP_EXP_REPORT_DISTS.REPORT_DISTRIBUTION_ID%TYPE;

699: l_report_distribution_id expDist_REPORT_DISTRIBUTION_ID;
700: c_line_ccid_cursor AP_WEB_DB_EXPLINE_PKG.ExpLineCCIDCursor;
701: l_report_line_id AP_WEB_DB_EXPLINE_PKG.expLines_report_line_id;
702: l_line_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
703: l_dist_id AP_EXP_REPORT_DISTS.REPORT_DISTRIBUTION_ID%TYPE;
704: l_line_amount NUMBER;
705: BEGIN
706:
707: IF (AP_WEB_DB_EXPLINE_PKG.GetLineCCIDCursor(p_report_header_id, c_line_ccid_cursor)) THEN

Line 717: FROM ap_exp_report_dists

713: BEGIN
714: /* If there is no distribution line, add one. */
715: SELECT report_distribution_id
716: INTO l_dist_id
717: FROM ap_exp_report_dists
718: WHERE report_header_id = p_report_header_id
719: AND report_line_id = l_report_line_id;
720:
721: EXCEPTION

Line 751: INSERT INTO AP_EXP_REPORT_DISTS

747: 'start AddDistributionLine');
748: l_sequence_num := 0;
749:
750: -- For the given line, duplicate its distributions
751: INSERT INTO AP_EXP_REPORT_DISTS
752: (
753: report_header_id,
754: report_line_id,
755: report_distribution_id,

Line 803: AP_EXP_REPORT_DISTS_S.NEXTVAL,

799: )
800: SELECT
801: XL.report_header_id,
802: XL.report_line_id,
803: AP_EXP_REPORT_DISTS_S.NEXTVAL,
804: l_sequence_num,
805: SYSDATE,
806: XL.last_updated_by,
807: SYSDATE,

Line 888: l_amount ap_exp_report_dists_all.amount%TYPE;

884: l_created_by NUMBER;
885: l_report_distribution_id expDist_REPORT_DISTRIBUTION_ID;
886: l_code_combination_id expDist_CODE_COMBINATION_ID;
887: l_org_id NUMBER;
888: l_amount ap_exp_report_dists_all.amount%TYPE;
889: l_project_id ap_exp_report_dists_all.project_id%TYPE;
890: l_task_id ap_exp_report_dists_all.task_id%TYPE;
891: l_award_id ap_exp_report_dists_all.award_id%TYPE;
892: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;

Line 889: l_project_id ap_exp_report_dists_all.project_id%TYPE;

885: l_report_distribution_id expDist_REPORT_DISTRIBUTION_ID;
886: l_code_combination_id expDist_CODE_COMBINATION_ID;
887: l_org_id NUMBER;
888: l_amount ap_exp_report_dists_all.amount%TYPE;
889: l_project_id ap_exp_report_dists_all.project_id%TYPE;
890: l_task_id ap_exp_report_dists_all.task_id%TYPE;
891: l_award_id ap_exp_report_dists_all.award_id%TYPE;
892: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;
893: l_cost_center ap_exp_report_dists_all.cost_center%TYPE;

Line 890: l_task_id ap_exp_report_dists_all.task_id%TYPE;

886: l_code_combination_id expDist_CODE_COMBINATION_ID;
887: l_org_id NUMBER;
888: l_amount ap_exp_report_dists_all.amount%TYPE;
889: l_project_id ap_exp_report_dists_all.project_id%TYPE;
890: l_task_id ap_exp_report_dists_all.task_id%TYPE;
891: l_award_id ap_exp_report_dists_all.award_id%TYPE;
892: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;
893: l_cost_center ap_exp_report_dists_all.cost_center%TYPE;
894:

Line 891: l_award_id ap_exp_report_dists_all.award_id%TYPE;

887: l_org_id NUMBER;
888: l_amount ap_exp_report_dists_all.amount%TYPE;
889: l_project_id ap_exp_report_dists_all.project_id%TYPE;
890: l_task_id ap_exp_report_dists_all.task_id%TYPE;
891: l_award_id ap_exp_report_dists_all.award_id%TYPE;
892: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;
893: l_cost_center ap_exp_report_dists_all.cost_center%TYPE;
894:
895: -- BUG 7025517

Line 892: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;

888: l_amount ap_exp_report_dists_all.amount%TYPE;
889: l_project_id ap_exp_report_dists_all.project_id%TYPE;
890: l_task_id ap_exp_report_dists_all.task_id%TYPE;
891: l_award_id ap_exp_report_dists_all.award_id%TYPE;
892: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;
893: l_cost_center ap_exp_report_dists_all.cost_center%TYPE;
894:
895: -- BUG 7025517
896: p_seg1 varchar2(25);

Line 893: l_cost_center ap_exp_report_dists_all.cost_center%TYPE;

889: l_project_id ap_exp_report_dists_all.project_id%TYPE;
890: l_task_id ap_exp_report_dists_all.task_id%TYPE;
891: l_award_id ap_exp_report_dists_all.award_id%TYPE;
892: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;
893: l_cost_center ap_exp_report_dists_all.cost_center%TYPE;
894:
895: -- BUG 7025517
896: p_seg1 varchar2(25);
897: p_seg2 varchar2(25);

Line 968: l_debug_info := 'get next AP_EXP_REPORT_DISTS_S';

964: WHERE XL.report_line_id = p_report_line_id
965: AND XL.report_header_id = XH.report_header_id;
966:
967: -----------------------------------------------------
968: l_debug_info := 'get next AP_EXP_REPORT_DISTS_S';
969: -----------------------------------------------------
970: SELECT AP_EXP_REPORT_DISTS_S.NEXTVAL
971: INTO l_report_distribution_id
972: FROM DUAL;

Line 970: SELECT AP_EXP_REPORT_DISTS_S.NEXTVAL

966:
967: -----------------------------------------------------
968: l_debug_info := 'get next AP_EXP_REPORT_DISTS_S';
969: -----------------------------------------------------
970: SELECT AP_EXP_REPORT_DISTS_S.NEXTVAL
971: INTO l_report_distribution_id
972: FROM DUAL;
973:
974: l_sqlstmt := 'INSERT INTO AP_EXP_REPORT_DISTS ( ';

Line 974: l_sqlstmt := 'INSERT INTO AP_EXP_REPORT_DISTS ( ';

970: SELECT AP_EXP_REPORT_DISTS_S.NEXTVAL
971: INTO l_report_distribution_id
972: FROM DUAL;
973:
974: l_sqlstmt := 'INSERT INTO AP_EXP_REPORT_DISTS ( ';
975: l_sqlstmt := l_sqlstmt || 'report_header_id, ';
976: l_sqlstmt := l_sqlstmt || 'report_line_id, ';
977: l_sqlstmt := l_sqlstmt || 'report_distribution_id, ';
978: l_sqlstmt := l_sqlstmt || 'sequence_num, ';

Line 1286: FROM AP_EXP_REPORT_DISTS

1282:
1283: -- Check if project-related dist exists
1284: SELECT 'dist exists'
1285: INTO V_Temp
1286: FROM AP_EXP_REPORT_DISTS
1287: WHERE REPORT_HEADER_ID = p_report_header_id
1288: AND PROJECT_ID IS NOT NULL
1289: AND TASK_ID IS NOT NULL;
1290:

Line 1317: FROM AP_EXP_REPORT_DISTS

1313:
1314: -- Check if non-project-related dist exists
1315: SELECT 'dist exists'
1316: INTO V_Temp
1317: FROM AP_EXP_REPORT_DISTS
1318: WHERE REPORT_HEADER_ID = p_report_header_id
1319: AND PROJECT_ID IS NULL
1320: AND TASK_ID IS NULL;
1321: