APPS.PSP_EFFORTS_PKG dependencies on PSP_EFFORT_REPORT_DETAILS

Line 271: FROM psp_effort_report_details

267: BEGIN
268: BEGIN
269: SELECT 'x'
270: INTO t_dummy
271: FROM psp_effort_report_details
272: WHERE effort_report_id = effort_report_id1 AND
273: version_num = version_number1 AND
274: ROWNUM = 1;
275: RETURN(0);

Line 323: DELETE FROM PSP_EFFORT_REPORT_DETAILS D

319: PSP_EFT_REPORT_TEMPLATES_PKG.delete_row(t_old_template_id);
320: IF (SQL%NOTFOUND) THEN
321: NULL;
322: END IF;
323: DELETE FROM PSP_EFFORT_REPORT_DETAILS D
324: WHERE exists ( SELECT 'x'
325: FROM PSP_EFFORT_REPORTS R
326: WHERE R.effort_report_id = D.effort_report_id AND
327: R.version_num = D.version_num AND

Line 352: --- the TOTAL_AMOUNT column of PSP_EFFORT_REPORT_DETAILS, instead of creating a new row.

348: gl_poeta1 IN g_gl_poeta%ROWTYPE, total_amount1 IN NUMBER)
349: --- The following private function checks to see if combination of person, date range,
350: --- Assignment, element type, GL, POETA already exists, for a particular version. If yes,
351: --- the function adds distribution amount already fetched from Distribution lines to
352: --- the TOTAL_AMOUNT column of PSP_EFFORT_REPORT_DETAILS, instead of creating a new row.
353: RETURN NUMBER IS
354: BEGIN
355: BEGIN
356: SELECT *

Line 358: FROM psp_effort_report_details

354: BEGIN
355: BEGIN
356: SELECT *
357: INTO g_details_row
358: FROM psp_effort_report_details
359: WHERE effort_report_id = effort_report_id1 AND
360: version_num = version_num1 AND
361: assignment_id = assignment_id1 AND
362: element_type_id = element_type_id1 AND

Line 373: UPDATE PSP_EFFORT_REPORT_DETAILS

369: ROWNUM = 1;
370: ---
371: g_details_row.TOTAL_AMOUNT := g_details_row.TOTAL_AMOUNT + total_amount1;
372: ---
373: UPDATE PSP_EFFORT_REPORT_DETAILS
374: SET total_amount = g_details_row.TOTAL_AMOUNT
375: WHERE effort_report_id = g_details_row.effort_report_id AND
376: version_num = g_details_row.version_num AND
377: effort_report_line_num = g_details_row.effort_report_line_num;

Line 1043: --- Insert in psp_effort_report_details rows which passed the criteria

1039: NULL;
1040: END IF;
1041: END IF;
1042: ---
1043: --- Insert in psp_effort_report_details rows which passed the criteria
1044: ---
1045: IF p_sync_details(t_effort_report_id,t_version_number,
1046: t_DIST_row.assignment_id,t_DIST_row.element_type_id,
1047: g_poeta_row,

Line 1071: FROM psp_effort_report_details

1067: ---
1068: IF NOT(g_template_row.report_type = 'N' AND t_status_code = 'W') THEN
1069: SELECT NVL(MAX(effort_report_line_num) + 1,1)
1070: INTO t_effort_report_line_num
1071: FROM psp_effort_report_details
1072: WHERE effort_report_id = t_effort_report_id AND
1073: version_num = t_version_number;
1074: ---
1075: PSP_EFFORT_REPORT_DETAILS_PKG.insert_row (

Line 1075: PSP_EFFORT_REPORT_DETAILS_PKG.insert_row (

1071: FROM psp_effort_report_details
1072: WHERE effort_report_id = t_effort_report_id AND
1073: version_num = t_version_number;
1074: ---
1075: PSP_EFFORT_REPORT_DETAILS_PKG.insert_row (
1076: t_rowid, --- in out NOCOPY VARCHAR2,
1077: t_effort_report_id, --- in NUMBER,
1078: t_version_number, --- in NUMBER,
1079: t_effort_report_line_num, --- in NUMBER,