DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_PROGRESS_REPORT_PKG

Line 149: pa_progress_report_pkg.INSERT_progress_report_VAL_ROW (

145: -- ELSE
146: -- l_record_sequence := p_record_sequence;
147: -- END IF;
148:
149: pa_progress_report_pkg.INSERT_progress_report_VAL_ROW (
150: P_VERSION_ID,
151: P_REGION_SOURCE_TYPE,
152: P_REGION_CODE,
153: P_RECORD_SEQUENCE,

Line 439: PA_PROGRESS_REPORT_PKG.update_progress_report_val_row

435: --debug_msg ('P_ATTRIBUTE7' || P_ATTRIBUTE8);
436: --debug_msg ('P_ATTRIBUTE7' || P_ATTRIBUTE9);
437:
438: -- we can update it now
439: PA_PROGRESS_REPORT_PKG.update_progress_report_val_row
440: (
441: P_VERSION_ID ,
442: P_REGION_SOURCE_TYPE,
443: P_REGION_CODE ,

Line 670: pa_progress_report_pkg.delete_progress_report_region(

666: */
667:
668: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) THEN
669: IF (p_record_sequence IS null) THEN
670: pa_progress_report_pkg.delete_progress_report_region(
671: P_VERSION_ID,
672: P_REGION_SOURCE_TYPE,
673: P_REGION_CODE,
674: x_return_status,

Line 680: pa_progress_report_pkg.DELETE_progress_report_VAL_ROW (

676: x_msg_data
677: );
678:
679: else
680: pa_progress_report_pkg.DELETE_progress_report_VAL_ROW (
681: P_VERSION_ID,
682: P_REGION_SOURCE_TYPE,
683: P_REGION_CODE,
684: P_RECORD_SEQUENCE,

Line 840: /* pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW

836:
837: -- change the status of report to obsoleted.
838: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
839:
840: /* pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW
841: (
842: p_version_id,
843: NULL,
844: NULL,

Line 893: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW

889: open update_last_published_rep;
890: fetch update_last_published_rep into l_version_id,l_RECORD_VERSION_NUMBER,l_summary_version_number;
891: IF update_last_published_rep%found then
892:
893: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW
894: (
895: l_version_id,
896: NULL,
897: NULL,

Line 1030: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW

1026:
1027: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
1028:
1029: /*
1030: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW
1031: (
1032: p_version_id,
1033: NULL,
1034: NULL,

Line 1181: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW

1177:
1178: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
1179:
1180: /*
1181: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW
1182: (
1183: p_version_id,
1184: NULL,
1185: NULL,

Line 1377: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW

1373: --debug_msg ('before update 2' || To_char(l_reported_by));
1374: --debug_msg ('before update 3' || p_overview);
1375: --debug_msg ('before update 4' || p_progress_status);
1376:
1377: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW
1378: (
1379: p_version_id,
1380: NULL,
1381: NULL,

Line 1762: pa_progress_report_pkg.insert_object_page_layout_row

1758:
1759: -- we will insert into pa_object_page_layouts
1760: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) THEN
1761:
1762: pa_progress_report_pkg.insert_object_page_layout_row
1763: (
1764: P_OBJECT_ID ,
1765: P_OBJECT_TYPE ,
1766: L_PAGE_ID ,

Line 1842: pa_progress_report_pkg.update_object_page_layout_row

1838: -- we will insert into pa_object_page_layouts
1839: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) THEN
1840:
1841:
1842: pa_progress_report_pkg.update_object_page_layout_row
1843: (
1844: P_OBJECT_ID ,
1845: P_OBJECT_TYPE ,
1846: L_PAGE_ID ,

Line 2109: pa_progress_report_pkg.delete_progress_report_vals

2105:
2106: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
2107:
2108: -- delete all records in pa_progress_report_vals under the p_version_id
2109: pa_progress_report_pkg.delete_progress_report_vals
2110: (
2111: p_version_id,
2112: x_return_status ,
2113: x_msg_count ,

Line 2120: pa_progress_report_pkg.delete_progress_report_ver_row

2116:
2117: IF (x_return_status = FND_API.g_ret_sts_success) THEN
2118:
2119: -- delete record in pa_progress_report_vers under the p_version_id
2120: pa_progress_report_pkg.delete_progress_report_ver_row
2121: (
2122: p_version_id,
2123: p_record_version_number,
2124: x_return_status ,

Line 2267: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW

2263:
2264: -- set the status to working first
2265:
2266: /*
2267: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW
2268: (
2269: p_version_id ,
2270: NULL,
2271: NULL,

Line 2521: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW

2517: -- set the status to working first
2518:
2519: --debug_msg('UPDATE_PROGRESS_REPORT_VER_ROW');
2520: /*
2521: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW
2522: (
2523: p_version_id,
2524: NULL,
2525: NULL,

Line 2620: pa_progress_report_pkg.update_object_page_layout_row

2616: );
2617:
2618:
2619: --debug_msg('update_object_page_layout_row');
2620: pa_progress_report_pkg.update_object_page_layout_row
2621: (
2622: l_OBJECT_ID ,
2623: l_OBJECT_TYPE ,
2624: null ,

Line 2792: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW

2788: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
2789:
2790: -- set the status to working first
2791:
2792: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW
2793: (
2794: p_version_id,
2795: NULL,
2796: NULL,

Line 3019: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW

3015: and current_flag = 'Y';
3016:
3017: if (l_report_end_date >= x_report_end_Date) then
3018: l_current_flag := 'Y';
3019: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW
3020: (
3021: x_version_id,
3022: NULL,
3023: NULL,

Line 3063: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW

3059: end if;
3060:
3061: -- change the progress status, launch the workflow if necessary
3062: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
3063: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW
3064: (
3065: p_version_id,
3066: NULL,
3067: NULL,

Line 3444: pa_progress_report_pkg.insert_PROGRESS_REPORT_ver_row

3440: ------CLOSE get_resource_id;
3441: l_person_id := pa_resource_utils.get_resource_id(p_user_id => FND_GLOBAL.user_id);
3442:
3443: --debug_msg ('l_person_id' || To_char(l_person_id));
3444: pa_progress_report_pkg.insert_PROGRESS_REPORT_ver_row
3445: (
3446: p_object_id,
3447: p_object_type,
3448: l_page_id,

Line 3498: pa_progress_report_pkg.insert_progress_report_val_row

3494:
3495: --debug_msg ('no published report' || obj_page_value_rec.view_region_code);
3496:
3497: -- debug_msg('insert val' || obj_page_value_rec.view_region_code);
3498: pa_progress_report_pkg.insert_progress_report_val_row
3499: (
3500: x_version_id,
3501: obj_page_value_rec.region_source_type,
3502: obj_page_value_rec.region_source_code,

Line 3587: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW (

3583:
3584: --END IF;
3585:
3586: --debug_msg ('copying overview ' || l_overview);
3587: pa_progress_report_pkg.UPDATE_PROGRESS_REPORT_VER_ROW (
3588: x_version_id,
3589: null,
3590: NULL,
3591: NULL,

Line 3626: pa_progress_report_pkg.insert_progress_report_val_row

3622: -- copy it, create entries in pa_progress_report_vals table
3623: FOR obj_page_value_rec IN get_all_regions LOOP
3624:
3625: --debug_msg ('published report' || obj_page_value_rec.region_code);
3626: pa_progress_report_pkg.insert_progress_report_val_row
3627: (
3628: x_version_id,
3629: obj_page_value_rec.region_source_type,
3630: obj_page_value_rec.region_code,