APPS.AMW_PROCCERT_REMINDER_PKG dependencies on AMW_PROCCERT_REMINDER_PKG

Line 1: PACKAGE BODY AMW_PROCCERT_REMINDER_PKG AS

1: PACKAGE BODY AMW_PROCCERT_REMINDER_PKG AS
2: /* $Header: amwpsrmb.pls 120.0.12000000.2 2007/03/29 16:04:13 hyuen ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMW_PROCCERT_REMINDER_PKG

2: /* $Header: amwpsrmb.pls 120.0.12000000.2 2007/03/29 16:04:13 hyuen ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMW_PROCCERT_REMINDER_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 15: --G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_PROCCERT_REMINDER_PKG';

11: -- NOTE
12: --
13: -- End of Comments
14: -- ===============================================================
15: --G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_PROCCERT_REMINDER_PKG';
16: --G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwpsrmb.pls';
17:
18: TYPE t_proc_owner_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
19: g_proc_owner_tbl t_proc_owner_tbl;

Line 300: AMW_PROCCERT_REMINDER_PKG.send_reminder_to_owner

296: end loop;
297:
298: /* hyuen start bug 5098058
299: FOR i IN 1..l_owner_tbl.count LOOP
300: AMW_PROCCERT_REMINDER_PKG.send_reminder_to_owner
301: ( p_certification_id => cert_rec.certification_id,
302: p_process_owner_id => l_owner_tbl(i),
303: x_return_status => x_return_status);
304: END LOOP; */

Line 307: amw_proccert_reminder_pkg.send_reminder_to_owner

303: x_return_status => x_return_status);
304: END LOOP; */
305:
306: FOR i IN 1 .. g_ownerList_tbl.COUNT LOOP
307: amw_proccert_reminder_pkg.send_reminder_to_owner
308: ( p_certification_id => cert_rec.certification_id,
309: p_process_owner_id => g_ownerList_tbl(i),
310: x_return_status => x_return_status);
311: END LOOP;

Line 314: AMW_PROCCERT_REMINDER_PKG.update_lastreminder_date

310: x_return_status => x_return_status);
311: END LOOP;
312: /* hyuen end bug 5098058 */
313:
314: AMW_PROCCERT_REMINDER_PKG.update_lastreminder_date
315: (p_certificaion_id => cert_rec.certification_id ,
316: x_return_status => x_return_status);
317: COMMIT;
318: end loop;

Line 587: AMW_PROCCERT_REMINDER_PKG.send_reminder_to_owner

583: END LOOP;
584:
585: /* hyuen start bug 5098058
586: FOR i IN 1..l_owner_tbl.count LOOP
587: AMW_PROCCERT_REMINDER_PKG.send_reminder_to_owner
588: ( p_certification_id => p_entity_id,
589: p_process_owner_id => l_owner_tbl(i),
590: p_organization_id => p_organization_id,
591: p_process_id => p_process_id,

Line 595: amw_proccert_reminder_pkg.send_reminder_to_owner

591: p_process_id => p_process_id,
592: x_return_status => lx_return_status);
593: END LOOP; */
594: FOR i IN 1 .. g_ownerList_tbl.COUNT LOOP
595: amw_proccert_reminder_pkg.send_reminder_to_owner
596: (p_certification_id => p_entity_id,
597: p_process_owner_id => g_ownerList_tbl(i),
598: p_organization_id => p_organization_id,
599: p_process_id => p_process_id,

Line 614: END AMW_PROCCERT_REMINDER_PKG ;

610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: END send_reminder_selected_procs;
612:
613:
614: END AMW_PROCCERT_REMINDER_PKG ;