APPS.AMW_PROCESS_PKG dependencies on AMW_PROCESS

Line 1: PACKAGE BODY AMW_PROCESS_PKG as

1: PACKAGE BODY AMW_PROCESS_PKG as
2: /* $Header: amwtprlb.pls 120.0 2005/05/31 18:37:15 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMW_PROCESS_PKG

2: /* $Header: amwtprlb.pls 120.0 2005/05/31 18:37:15 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMW_PROCESS_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_PROCESS_PKG';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_PROCESS_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwtprlb.pls';
19:
20: ----------------------------------------------------------
21: ---- MEDIA ----

Line 100: -- AMW_PROCESS_PKG.Update_Row (

96: -- user_id := -1;
97: -- end if;
98:
99: -- user_id := 1;
100: -- AMW_PROCESS_PKG.Update_Row (
101: -- p_significant_process_flag => p_significant_process_flag,
102: -- p_standard_process_flag => p_standard_process_flag,
103: -- p_approval_status => p_approval_status,
104: -- p_certification_status => p_certification_status,

Line 149: -- AMW_PROCESS_PKG.Insert_Row(

145: --
146: --exception
147: -- when NO_DATA_FOUND then
148: --
149: -- AMW_PROCESS_PKG.Insert_Row(
150: -- p_significant_process_flag => p_significant_process_flag,
151: -- p_standard_process_flag => p_standard_process_flag,
152: -- p_approval_status => p_approval_status,
153: -- p_certification_status => p_certification_status,

Line 274: INSERT INTO AMW_PROCESS(

270:
271: px_object_version_number := 1;
272:
273:
274: INSERT INTO AMW_PROCESS(
275: significant_process_flag,
276: standard_process_flag,
277: approval_status,
278: certification_status,

Line 432: select object_version_number from amw_process where process_rev_id=p_process_rev_id;

428: p_process_id NUMBER)
429:
430: IS
431: cursor c1 is
432: select object_version_number from amw_process where process_rev_id=p_process_rev_id;
433:
434: l_obj_num c1%rowtype;
435: l_object_version_number number := 0;
436:

Line 444: Update AMW_PROCESS

440: close c1;
441:
442: l_object_version_number := l_obj_num.object_version_number+1;
443:
444: Update AMW_PROCESS
445: SET
446: significant_process_flag = DECODE(p_significant_process_flag, FND_API.g_miss_char, significant_process_flag, p_significant_process_flag),
447: standard_process_flag = DECODE(p_standard_process_flag, FND_API.g_miss_char, standard_process_flag, p_standard_process_flag),
448: approval_status = DECODE(p_approval_status, FND_API.g_miss_char, approval_status, p_approval_status),

Line 517: DELETE FROM AMW_PROCESS

513: PROCEDURE Delete_Row(
514: p_PROCESS_rev_ID NUMBER)
515: IS
516: BEGIN
517: DELETE FROM AMW_PROCESS
518: WHERE PROCESS_rev_ID = p_PROCESS_rev_ID;
519: If (SQL%NOTFOUND) then
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: End If;

Line 591: FROM AMW_PROCESS

587:
588: IS
589: CURSOR C IS
590: SELECT *
591: FROM AMW_PROCESS
592: WHERE PROCESS_rev_ID = p_PROCESS_rev_ID
593: FOR UPDATE of PROCESS_rev_ID NOWAIT;
594: Recinfo C%ROWTYPE;
595: BEGIN

Line 716: END AMW_PROCESS_PKG;

712: APP_EXCEPTION.RAISE_EXCEPTION;
713: END IF;
714: END Lock_Row;
715:
716: END AMW_PROCESS_PKG;