DBA Data[Home] [Help]

APPS.AML_MONITOR_CONDITIONS_PUB dependencies on FND_API

Line 13: MONITOR_CONDITION_ID NUMBER := FND_API.G_MISS_NUM

9: -- End of Comments
10:
11: TYPE CONDITION_Rec_Type IS RECORD
12: (
13: MONITOR_CONDITION_ID NUMBER := FND_API.G_MISS_NUM
14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM

Line 14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE

10:
11: TYPE CONDITION_Rec_Type IS RECORD
12: (
13: MONITOR_CONDITION_ID NUMBER := FND_API.G_MISS_NUM
14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

Line 15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM

11: TYPE CONDITION_Rec_Type IS RECORD
12: (
13: MONITOR_CONDITION_ID NUMBER := FND_API.G_MISS_NUM
14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM

Line 16: , CREATION_DATE DATE := FND_API.G_MISS_DATE

12: (
13: MONITOR_CONDITION_ID NUMBER := FND_API.G_MISS_NUM
14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM

Line 17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM

13: MONITOR_CONDITION_ID NUMBER := FND_API.G_MISS_NUM
14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM

Line 18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM

Line 19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM

15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE

Line 20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM

16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM

Line 21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM

17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , MONITOR_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM

18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , MONITOR_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , TIME_LAG_NUM NUMBER := FND_API.G_MISS_NUM

Line 23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE

19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , MONITOR_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , TIME_LAG_NUM NUMBER := FND_API.G_MISS_NUM
27: , TIME_LAG_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM

20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , MONITOR_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , TIME_LAG_NUM NUMBER := FND_API.G_MISS_NUM
27: , TIME_LAG_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
28: , TIME_LAG_FROM_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR

Line 25: , MONITOR_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR

21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , MONITOR_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , TIME_LAG_NUM NUMBER := FND_API.G_MISS_NUM
27: , TIME_LAG_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
28: , TIME_LAG_FROM_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
29: , TIME_LAG_TO_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR

Line 26: , TIME_LAG_NUM NUMBER := FND_API.G_MISS_NUM

22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , MONITOR_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , TIME_LAG_NUM NUMBER := FND_API.G_MISS_NUM
27: , TIME_LAG_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
28: , TIME_LAG_FROM_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
29: , TIME_LAG_TO_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
30: , Expiration_Relative varchar2(1) := FND_API.G_MISS_CHAR

Line 27: , TIME_LAG_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR

23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , MONITOR_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , TIME_LAG_NUM NUMBER := FND_API.G_MISS_NUM
27: , TIME_LAG_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
28: , TIME_LAG_FROM_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
29: , TIME_LAG_TO_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
30: , Expiration_Relative varchar2(1) := FND_API.G_MISS_CHAR
31: , Reminder_Defined varchar2(1) := FND_API.G_MISS_CHAR

Line 28: , TIME_LAG_FROM_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR

24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , MONITOR_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , TIME_LAG_NUM NUMBER := FND_API.G_MISS_NUM
27: , TIME_LAG_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
28: , TIME_LAG_FROM_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
29: , TIME_LAG_TO_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
30: , Expiration_Relative varchar2(1) := FND_API.G_MISS_CHAR
31: , Reminder_Defined varchar2(1) := FND_API.G_MISS_CHAR
32: , Total_Reminders number := FND_API.G_MISS_NUM

Line 29: , TIME_LAG_TO_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR

25: , MONITOR_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , TIME_LAG_NUM NUMBER := FND_API.G_MISS_NUM
27: , TIME_LAG_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
28: , TIME_LAG_FROM_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
29: , TIME_LAG_TO_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
30: , Expiration_Relative varchar2(1) := FND_API.G_MISS_CHAR
31: , Reminder_Defined varchar2(1) := FND_API.G_MISS_CHAR
32: , Total_Reminders number := FND_API.G_MISS_NUM
33: , Reminder_Frequency number := FND_API.G_MISS_NUM

Line 30: , Expiration_Relative varchar2(1) := FND_API.G_MISS_CHAR

26: , TIME_LAG_NUM NUMBER := FND_API.G_MISS_NUM
27: , TIME_LAG_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
28: , TIME_LAG_FROM_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
29: , TIME_LAG_TO_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
30: , Expiration_Relative varchar2(1) := FND_API.G_MISS_CHAR
31: , Reminder_Defined varchar2(1) := FND_API.G_MISS_CHAR
32: , Total_Reminders number := FND_API.G_MISS_NUM
33: , Reminder_Frequency number := FND_API.G_MISS_NUM
34: , Reminder_Freq_uom_code varchar2(30) := FND_API.G_MISS_CHAR

Line 31: , Reminder_Defined varchar2(1) := FND_API.G_MISS_CHAR

27: , TIME_LAG_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
28: , TIME_LAG_FROM_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
29: , TIME_LAG_TO_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
30: , Expiration_Relative varchar2(1) := FND_API.G_MISS_CHAR
31: , Reminder_Defined varchar2(1) := FND_API.G_MISS_CHAR
32: , Total_Reminders number := FND_API.G_MISS_NUM
33: , Reminder_Frequency number := FND_API.G_MISS_NUM
34: , Reminder_Freq_uom_code varchar2(30) := FND_API.G_MISS_CHAR
35: , Timeout_Defined varchar2(10) := FND_API.G_MISS_CHAR

Line 32: , Total_Reminders number := FND_API.G_MISS_NUM

28: , TIME_LAG_FROM_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
29: , TIME_LAG_TO_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
30: , Expiration_Relative varchar2(1) := FND_API.G_MISS_CHAR
31: , Reminder_Defined varchar2(1) := FND_API.G_MISS_CHAR
32: , Total_Reminders number := FND_API.G_MISS_NUM
33: , Reminder_Frequency number := FND_API.G_MISS_NUM
34: , Reminder_Freq_uom_code varchar2(30) := FND_API.G_MISS_CHAR
35: , Timeout_Defined varchar2(10) := FND_API.G_MISS_CHAR
36: , Timeout_Duration number := FND_API.G_MISS_NUM

Line 33: , Reminder_Frequency number := FND_API.G_MISS_NUM

29: , TIME_LAG_TO_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
30: , Expiration_Relative varchar2(1) := FND_API.G_MISS_CHAR
31: , Reminder_Defined varchar2(1) := FND_API.G_MISS_CHAR
32: , Total_Reminders number := FND_API.G_MISS_NUM
33: , Reminder_Frequency number := FND_API.G_MISS_NUM
34: , Reminder_Freq_uom_code varchar2(30) := FND_API.G_MISS_CHAR
35: , Timeout_Defined varchar2(10) := FND_API.G_MISS_CHAR
36: , Timeout_Duration number := FND_API.G_MISS_NUM
37: , Timeout_uom_code varchar2(30) := FND_API.G_MISS_CHAR

Line 34: , Reminder_Freq_uom_code varchar2(30) := FND_API.G_MISS_CHAR

30: , Expiration_Relative varchar2(1) := FND_API.G_MISS_CHAR
31: , Reminder_Defined varchar2(1) := FND_API.G_MISS_CHAR
32: , Total_Reminders number := FND_API.G_MISS_NUM
33: , Reminder_Frequency number := FND_API.G_MISS_NUM
34: , Reminder_Freq_uom_code varchar2(30) := FND_API.G_MISS_CHAR
35: , Timeout_Defined varchar2(10) := FND_API.G_MISS_CHAR
36: , Timeout_Duration number := FND_API.G_MISS_NUM
37: , Timeout_uom_code varchar2(30) := FND_API.G_MISS_CHAR
38: , Notify_Owner VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 35: , Timeout_Defined varchar2(10) := FND_API.G_MISS_CHAR

31: , Reminder_Defined varchar2(1) := FND_API.G_MISS_CHAR
32: , Total_Reminders number := FND_API.G_MISS_NUM
33: , Reminder_Frequency number := FND_API.G_MISS_NUM
34: , Reminder_Freq_uom_code varchar2(30) := FND_API.G_MISS_CHAR
35: , Timeout_Defined varchar2(10) := FND_API.G_MISS_CHAR
36: , Timeout_Duration number := FND_API.G_MISS_NUM
37: , Timeout_uom_code varchar2(30) := FND_API.G_MISS_CHAR
38: , Notify_Owner VARCHAR2(1) := FND_API.G_MISS_CHAR
39: , Notify_Owner_Manager VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 36: , Timeout_Duration number := FND_API.G_MISS_NUM

32: , Total_Reminders number := FND_API.G_MISS_NUM
33: , Reminder_Frequency number := FND_API.G_MISS_NUM
34: , Reminder_Freq_uom_code varchar2(30) := FND_API.G_MISS_CHAR
35: , Timeout_Defined varchar2(10) := FND_API.G_MISS_CHAR
36: , Timeout_Duration number := FND_API.G_MISS_NUM
37: , Timeout_uom_code varchar2(30) := FND_API.G_MISS_CHAR
38: , Notify_Owner VARCHAR2(1) := FND_API.G_MISS_CHAR
39: , Notify_Owner_Manager VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 37: , Timeout_uom_code varchar2(30) := FND_API.G_MISS_CHAR

33: , Reminder_Frequency number := FND_API.G_MISS_NUM
34: , Reminder_Freq_uom_code varchar2(30) := FND_API.G_MISS_CHAR
35: , Timeout_Defined varchar2(10) := FND_API.G_MISS_CHAR
36: , Timeout_Duration number := FND_API.G_MISS_NUM
37: , Timeout_uom_code varchar2(30) := FND_API.G_MISS_CHAR
38: , Notify_Owner VARCHAR2(1) := FND_API.G_MISS_CHAR
39: , Notify_Owner_Manager VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 38: , Notify_Owner VARCHAR2(1) := FND_API.G_MISS_CHAR

34: , Reminder_Freq_uom_code varchar2(30) := FND_API.G_MISS_CHAR
35: , Timeout_Defined varchar2(10) := FND_API.G_MISS_CHAR
36: , Timeout_Duration number := FND_API.G_MISS_NUM
37: , Timeout_uom_code varchar2(30) := FND_API.G_MISS_CHAR
38: , Notify_Owner VARCHAR2(1) := FND_API.G_MISS_CHAR
39: , Notify_Owner_Manager VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 39: , Notify_Owner_Manager VARCHAR2(1) := FND_API.G_MISS_CHAR

35: , Timeout_Defined varchar2(10) := FND_API.G_MISS_CHAR
36: , Timeout_Duration number := FND_API.G_MISS_NUM
37: , Timeout_uom_code varchar2(30) := FND_API.G_MISS_CHAR
38: , Notify_Owner VARCHAR2(1) := FND_API.G_MISS_CHAR
39: , Notify_Owner_Manager VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 40: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR

36: , Timeout_Duration number := FND_API.G_MISS_NUM
37: , Timeout_uom_code varchar2(30) := FND_API.G_MISS_CHAR
38: , Notify_Owner VARCHAR2(1) := FND_API.G_MISS_CHAR
39: , Notify_Owner_Manager VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 41: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR

37: , Timeout_uom_code varchar2(30) := FND_API.G_MISS_CHAR
38: , Notify_Owner VARCHAR2(1) := FND_API.G_MISS_CHAR
39: , Notify_Owner_Manager VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
45: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 42: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR

38: , Notify_Owner VARCHAR2(1) := FND_API.G_MISS_CHAR
39: , Notify_Owner_Manager VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
45: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
46: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 43: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR

39: , Notify_Owner_Manager VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
45: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
46: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
47: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 44: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR

40: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
45: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
46: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
47: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
48: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 45: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR

41: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
45: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
46: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
47: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
48: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
49: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 46: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR

42: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
45: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
46: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
47: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
48: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
49: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
50: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 47: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR

43: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
45: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
46: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
47: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
48: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
49: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
50: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
51: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 48: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR

44: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
45: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
46: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
47: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
48: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
49: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
50: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
51: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
52: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 49: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR

45: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
46: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
47: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
48: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
49: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
50: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
51: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
52: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
53: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 50: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR

46: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
47: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
48: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
49: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
50: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
51: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
52: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
53: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
54: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 51: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR

47: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
48: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
49: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
50: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
51: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
52: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
53: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
54: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
55: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 52: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR

48: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
49: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
50: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
51: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
52: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
53: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
54: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
55: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
56: );

Line 53: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR

49: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
50: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
51: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
52: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
53: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
54: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
55: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
56: );
57:

Line 54: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR

50: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
51: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
52: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
53: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
54: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
55: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
56: );
57:
58: G_MISS_CONDITION_REC CONDITION_Rec_Type;

Line 55: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR

51: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
52: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
53: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
54: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
55: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
56: );
57:
58: G_MISS_CONDITION_REC CONDITION_Rec_Type;
59:

Line 69: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

65: -- Pre-Req :
66: -- Parameters:
67: -- IN
68: -- p_api_version_number IN NUMBER Required
69: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
70: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
71: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
73: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

Line 70: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

66: -- Parameters:
67: -- IN
68: -- p_api_version_number IN NUMBER Required
69: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
70: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
71: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
73: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: -- p_admin_group_id IN NUMBER Required

Line 71: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

67: -- IN
68: -- p_api_version_number IN NUMBER Required
69: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
70: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
71: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
73: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: -- p_admin_group_id IN NUMBER Required
75: -- P_CONDITION_Rec IN CONDITION_Rec_Type Required

Line 72: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

68: -- p_api_version_number IN NUMBER Required
69: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
70: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
71: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
73: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: -- p_admin_group_id IN NUMBER Required
75: -- P_CONDITION_Rec IN CONDITION_Rec_Type Required
76: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

Line 73: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

69: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
70: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
71: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
73: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: -- p_admin_group_id IN NUMBER Required
75: -- P_CONDITION_Rec IN CONDITION_Rec_Type Required
76: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
77: --

Line 90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

86: -- End of Comments
87: --
88: PROCEDURE Create_monitor_condition(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Identity_Resource_Id IN NUMBER,
94: P_CONDITION_Rec IN CONDITION_Rec_Type := G_MISS_CONDITION_REC,

Line 91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

87: --
88: PROCEDURE Create_monitor_condition(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Identity_Resource_Id IN NUMBER,
94: P_CONDITION_Rec IN CONDITION_Rec_Type := G_MISS_CONDITION_REC,
95: X_MONITOR_CONDITION_ID OUT NOCOPY NUMBER,

Line 92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

88: PROCEDURE Create_monitor_condition(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Identity_Resource_Id IN NUMBER,
94: P_CONDITION_Rec IN CONDITION_Rec_Type := G_MISS_CONDITION_REC,
95: X_MONITOR_CONDITION_ID OUT NOCOPY NUMBER,
96: X_Return_Status OUT NOCOPY VARCHAR2,

Line 110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

106: -- Pre-Req :
107: -- Parameters:
108: -- IN
109: -- p_api_version_number IN NUMBER Required
110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
114: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

Line 111: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

107: -- Parameters:
108: -- IN
109: -- p_api_version_number IN NUMBER Required
110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
114: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_admin_group_id IN NUMBER Required

Line 112: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

108: -- IN
109: -- p_api_version_number IN NUMBER Required
110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
114: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_admin_group_id IN NUMBER Required
116: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

Line 113: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

109: -- p_api_version_number IN NUMBER Required
110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
114: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_admin_group_id IN NUMBER Required
116: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
117: -- P_CONDITION_Rec IN CONDITION_Rec_Type Required

Line 114: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
114: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_admin_group_id IN NUMBER Required
116: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
117: -- P_CONDITION_Rec IN CONDITION_Rec_Type Required
118: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

Line 133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

129: --
130: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
131: PROCEDURE Update_monitor_condition(
132: P_Api_Version_Number IN NUMBER,
133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
134: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: p_identity_salesforce_id IN NUMBER,
137: P_CONDITION_Rec IN CONDITION_Rec_Type,

Line 134: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

130: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
131: PROCEDURE Update_monitor_condition(
132: P_Api_Version_Number IN NUMBER,
133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
134: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: p_identity_salesforce_id IN NUMBER,
137: P_CONDITION_Rec IN CONDITION_Rec_Type,
138: X_Return_Status OUT NOCOPY VARCHAR2,

Line 135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

131: PROCEDURE Update_monitor_condition(
132: P_Api_Version_Number IN NUMBER,
133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
134: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: p_identity_salesforce_id IN NUMBER,
137: P_CONDITION_Rec IN CONDITION_Rec_Type,
138: X_Return_Status OUT NOCOPY VARCHAR2,
139: X_Msg_Count OUT NOCOPY NUMBER,

Line 152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

148: -- Pre-Req :
149: -- Parameters:
150: -- IN
151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

Line 153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

149: -- Parameters:
150: -- IN
151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_admin_group_id IN NUMBER Required

Line 154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

150: -- IN
151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_admin_group_id IN NUMBER Required
158: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

Line 155: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_admin_group_id IN NUMBER Required
158: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
159: -- P_CONDITION_Rec IN CONDITION_Rec_Type Required

Line 156: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_admin_group_id IN NUMBER Required
158: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
159: -- P_CONDITION_Rec IN CONDITION_Rec_Type Required
160: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

Line 176: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

172: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
173: -- The Master delete procedure may not be needed depends on different business requirements.
174: PROCEDURE Delete_monitor_condition(
175: P_Api_Version_Number IN NUMBER,
176: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
177: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_identity_salesforce_id IN NUMBER,
180: P_CONDITION_Rec IN CONDITION_Rec_Type,

Line 177: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

173: -- The Master delete procedure may not be needed depends on different business requirements.
174: PROCEDURE Delete_monitor_condition(
175: P_Api_Version_Number IN NUMBER,
176: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
177: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_identity_salesforce_id IN NUMBER,
180: P_CONDITION_Rec IN CONDITION_Rec_Type,
181: X_Return_Status OUT NOCOPY VARCHAR2,

Line 178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

174: PROCEDURE Delete_monitor_condition(
175: P_Api_Version_Number IN NUMBER,
176: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
177: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_identity_salesforce_id IN NUMBER,
180: P_CONDITION_Rec IN CONDITION_Rec_Type,
181: X_Return_Status OUT NOCOPY VARCHAR2,
182: X_Msg_Count OUT NOCOPY NUMBER,