APPS.ASO_DEPENDENCY_MAPPINGS_PKG dependencies on FND_API

Line 36: If (PX_DEPENDENCY_ID IS NULL) OR (PX_DEPENDENCY_ID = FND_API.G_MISS_NUM) then

32: )
33: IS
34: CURSOR C IS SELECT ASO_DEPENDENCY_MAPPINGS_S.nextval FROM sys.dual;
35: BEGIN
36: If (PX_DEPENDENCY_ID IS NULL) OR (PX_DEPENDENCY_ID = FND_API.G_MISS_NUM) then
37: OPEN C;
38: FETCH C INTO PX_DEPENDENCY_ID;
39: CLOSE C;
40: End If;

Line 60: decode( P_TRIGGER_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_TRIGGER_ATTRIBUTE_ID),

56: PROGRAM_ID,
57: PROGRAM_UPDATE_DATE
58: ) VALUES (
59: PX_DEPENDENCY_ID,
60: decode( P_TRIGGER_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_TRIGGER_ATTRIBUTE_ID),
61: decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_DEPENDENT_ATTRIBUTE_ID),
62: decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_ENABLED_FLAG),
63: decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, P_DATABASE_OBJECT_NAME),
64: decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, P_APPLICATION_ID),

Line 61: decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_DEPENDENT_ATTRIBUTE_ID),

57: PROGRAM_UPDATE_DATE
58: ) VALUES (
59: PX_DEPENDENCY_ID,
60: decode( P_TRIGGER_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_TRIGGER_ATTRIBUTE_ID),
61: decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_DEPENDENT_ATTRIBUTE_ID),
62: decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_ENABLED_FLAG),
63: decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, P_DATABASE_OBJECT_NAME),
64: decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, P_APPLICATION_ID),
65: decode( P_SEED_TAG, FND_API.G_MISS_CHAR, NULL, P_SEED_TAG),

Line 62: decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_ENABLED_FLAG),

58: ) VALUES (
59: PX_DEPENDENCY_ID,
60: decode( P_TRIGGER_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_TRIGGER_ATTRIBUTE_ID),
61: decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_DEPENDENT_ATTRIBUTE_ID),
62: decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_ENABLED_FLAG),
63: decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, P_DATABASE_OBJECT_NAME),
64: decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, P_APPLICATION_ID),
65: decode( P_SEED_TAG, FND_API.G_MISS_CHAR, NULL, P_SEED_TAG),
66: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),

Line 63: decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, P_DATABASE_OBJECT_NAME),

59: PX_DEPENDENCY_ID,
60: decode( P_TRIGGER_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_TRIGGER_ATTRIBUTE_ID),
61: decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_DEPENDENT_ATTRIBUTE_ID),
62: decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_ENABLED_FLAG),
63: decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, P_DATABASE_OBJECT_NAME),
64: decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, P_APPLICATION_ID),
65: decode( P_SEED_TAG, FND_API.G_MISS_CHAR, NULL, P_SEED_TAG),
66: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

Line 64: decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, P_APPLICATION_ID),

60: decode( P_TRIGGER_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_TRIGGER_ATTRIBUTE_ID),
61: decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_DEPENDENT_ATTRIBUTE_ID),
62: decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_ENABLED_FLAG),
63: decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, P_DATABASE_OBJECT_NAME),
64: decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, P_APPLICATION_ID),
65: decode( P_SEED_TAG, FND_API.G_MISS_CHAR, NULL, P_SEED_TAG),
66: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

Line 65: decode( P_SEED_TAG, FND_API.G_MISS_CHAR, NULL, P_SEED_TAG),

61: decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, P_DEPENDENT_ATTRIBUTE_ID),
62: decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_ENABLED_FLAG),
63: decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, P_DATABASE_OBJECT_NAME),
64: decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, P_APPLICATION_ID),
65: decode( P_SEED_TAG, FND_API.G_MISS_CHAR, NULL, P_SEED_TAG),
66: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
69: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),

Line 66: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),

62: decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_ENABLED_FLAG),
63: decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, P_DATABASE_OBJECT_NAME),
64: decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, P_APPLICATION_ID),
65: decode( P_SEED_TAG, FND_API.G_MISS_CHAR, NULL, P_SEED_TAG),
66: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
69: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
70: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

Line 67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

63: decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, P_DATABASE_OBJECT_NAME),
64: decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, P_APPLICATION_ID),
65: decode( P_SEED_TAG, FND_API.G_MISS_CHAR, NULL, P_SEED_TAG),
66: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
69: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
70: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
71: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

Line 68: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

64: decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, P_APPLICATION_ID),
65: decode( P_SEED_TAG, FND_API.G_MISS_CHAR, NULL, P_SEED_TAG),
66: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
69: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
70: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
71: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
72: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

Line 69: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),

65: decode( P_SEED_TAG, FND_API.G_MISS_CHAR, NULL, P_SEED_TAG),
66: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
69: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
70: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
71: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
72: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
73: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

Line 70: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

66: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
69: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
70: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
71: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
72: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
73: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
74: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE)

Line 71: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
69: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
70: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
71: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
72: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
73: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
74: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE)
75: );

Line 72: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

68: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
69: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
70: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
71: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
72: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
73: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
74: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE)
75: );
76:

Line 73: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

69: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
70: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
71: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
72: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
73: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
74: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE)
75: );
76:
77: END Insert_Row;

Line 74: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE)

70: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
71: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
72: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
73: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
74: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE)
75: );
76:
77: END Insert_Row;
78:

Line 101: TRIGGER_ATTRIBUTE_ID = decode( P_TRIGGER_ATTRIBUTE_ID, FND_API.G_MISS_NUM, TRIGGER_ATTRIBUTE_ID, P_TRIGGER_ATTRIBUTE_ID),

97: IS
98: BEGIN
99: Update ASO_DEPENDENCY_MAPPINGS
100: SET
101: TRIGGER_ATTRIBUTE_ID = decode( P_TRIGGER_ATTRIBUTE_ID, FND_API.G_MISS_NUM, TRIGGER_ATTRIBUTE_ID, P_TRIGGER_ATTRIBUTE_ID),
102: DEPENDENT_ATTRIBUTE_ID = decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, DEPENDENT_ATTRIBUTE_ID, P_DEPENDENT_ATTRIBUTE_ID),
103: ENABLED_FLAG = decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, P_ENABLED_FLAG),
104: DATABASE_OBJECT_NAME = decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, DATABASE_OBJECT_NAME, P_DATABASE_OBJECT_NAME),
105: APPLICATION_ID = decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, P_APPLICATION_ID),

Line 102: DEPENDENT_ATTRIBUTE_ID = decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, DEPENDENT_ATTRIBUTE_ID, P_DEPENDENT_ATTRIBUTE_ID),

98: BEGIN
99: Update ASO_DEPENDENCY_MAPPINGS
100: SET
101: TRIGGER_ATTRIBUTE_ID = decode( P_TRIGGER_ATTRIBUTE_ID, FND_API.G_MISS_NUM, TRIGGER_ATTRIBUTE_ID, P_TRIGGER_ATTRIBUTE_ID),
102: DEPENDENT_ATTRIBUTE_ID = decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, DEPENDENT_ATTRIBUTE_ID, P_DEPENDENT_ATTRIBUTE_ID),
103: ENABLED_FLAG = decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, P_ENABLED_FLAG),
104: DATABASE_OBJECT_NAME = decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, DATABASE_OBJECT_NAME, P_DATABASE_OBJECT_NAME),
105: APPLICATION_ID = decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, P_APPLICATION_ID),
106: SEED_TAG = decode( P_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, P_SEED_TAG),

Line 103: ENABLED_FLAG = decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, P_ENABLED_FLAG),

99: Update ASO_DEPENDENCY_MAPPINGS
100: SET
101: TRIGGER_ATTRIBUTE_ID = decode( P_TRIGGER_ATTRIBUTE_ID, FND_API.G_MISS_NUM, TRIGGER_ATTRIBUTE_ID, P_TRIGGER_ATTRIBUTE_ID),
102: DEPENDENT_ATTRIBUTE_ID = decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, DEPENDENT_ATTRIBUTE_ID, P_DEPENDENT_ATTRIBUTE_ID),
103: ENABLED_FLAG = decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, P_ENABLED_FLAG),
104: DATABASE_OBJECT_NAME = decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, DATABASE_OBJECT_NAME, P_DATABASE_OBJECT_NAME),
105: APPLICATION_ID = decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, P_APPLICATION_ID),
106: SEED_TAG = decode( P_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, P_SEED_TAG),
107: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 104: DATABASE_OBJECT_NAME = decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, DATABASE_OBJECT_NAME, P_DATABASE_OBJECT_NAME),

100: SET
101: TRIGGER_ATTRIBUTE_ID = decode( P_TRIGGER_ATTRIBUTE_ID, FND_API.G_MISS_NUM, TRIGGER_ATTRIBUTE_ID, P_TRIGGER_ATTRIBUTE_ID),
102: DEPENDENT_ATTRIBUTE_ID = decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, DEPENDENT_ATTRIBUTE_ID, P_DEPENDENT_ATTRIBUTE_ID),
103: ENABLED_FLAG = decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, P_ENABLED_FLAG),
104: DATABASE_OBJECT_NAME = decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, DATABASE_OBJECT_NAME, P_DATABASE_OBJECT_NAME),
105: APPLICATION_ID = decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, P_APPLICATION_ID),
106: SEED_TAG = decode( P_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, P_SEED_TAG),
107: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
108: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

Line 105: APPLICATION_ID = decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, P_APPLICATION_ID),

101: TRIGGER_ATTRIBUTE_ID = decode( P_TRIGGER_ATTRIBUTE_ID, FND_API.G_MISS_NUM, TRIGGER_ATTRIBUTE_ID, P_TRIGGER_ATTRIBUTE_ID),
102: DEPENDENT_ATTRIBUTE_ID = decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, DEPENDENT_ATTRIBUTE_ID, P_DEPENDENT_ATTRIBUTE_ID),
103: ENABLED_FLAG = decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, P_ENABLED_FLAG),
104: DATABASE_OBJECT_NAME = decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, DATABASE_OBJECT_NAME, P_DATABASE_OBJECT_NAME),
105: APPLICATION_ID = decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, P_APPLICATION_ID),
106: SEED_TAG = decode( P_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, P_SEED_TAG),
107: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
108: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
109: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 106: SEED_TAG = decode( P_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, P_SEED_TAG),

102: DEPENDENT_ATTRIBUTE_ID = decode( P_DEPENDENT_ATTRIBUTE_ID, FND_API.G_MISS_NUM, DEPENDENT_ATTRIBUTE_ID, P_DEPENDENT_ATTRIBUTE_ID),
103: ENABLED_FLAG = decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, P_ENABLED_FLAG),
104: DATABASE_OBJECT_NAME = decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, DATABASE_OBJECT_NAME, P_DATABASE_OBJECT_NAME),
105: APPLICATION_ID = decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, P_APPLICATION_ID),
106: SEED_TAG = decode( P_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, P_SEED_TAG),
107: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
108: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
109: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
110: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 107: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

103: ENABLED_FLAG = decode( P_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, P_ENABLED_FLAG),
104: DATABASE_OBJECT_NAME = decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, DATABASE_OBJECT_NAME, P_DATABASE_OBJECT_NAME),
105: APPLICATION_ID = decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, P_APPLICATION_ID),
106: SEED_TAG = decode( P_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, P_SEED_TAG),
107: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
108: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
109: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
110: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
111: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

Line 108: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

104: DATABASE_OBJECT_NAME = decode( P_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, DATABASE_OBJECT_NAME, P_DATABASE_OBJECT_NAME),
105: APPLICATION_ID = decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, P_APPLICATION_ID),
106: SEED_TAG = decode( P_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, P_SEED_TAG),
107: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
108: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
109: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
110: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
111: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
112: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

Line 109: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

105: APPLICATION_ID = decode( P_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, P_APPLICATION_ID),
106: SEED_TAG = decode( P_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, P_SEED_TAG),
107: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
108: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
109: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
110: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
111: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
112: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
113: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

Line 110: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

106: SEED_TAG = decode( P_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, P_SEED_TAG),
107: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
108: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
109: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
110: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
111: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
112: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
113: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
114: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

Line 111: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

107: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
108: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
109: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
110: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
111: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
112: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
113: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
114: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
115: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)

Line 112: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

108: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
109: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
110: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
111: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
112: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
113: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
114: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
115: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
116: where DEPENDENCY_ID = P_DEPENDENCY_ID;

Line 113: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

109: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
110: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
111: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
112: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
113: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
114: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
115: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
116: where DEPENDENCY_ID = P_DEPENDENCY_ID;
117:

Line 114: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

110: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
111: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
112: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
113: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
114: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
115: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
116: where DEPENDENCY_ID = P_DEPENDENCY_ID;
117:
118: If (SQL%NOTFOUND) then

Line 115: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)

111: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
112: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
113: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
114: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
115: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
116: where DEPENDENCY_ID = P_DEPENDENCY_ID;
117:
118: If (SQL%NOTFOUND) then
119: RAISE NO_DATA_FOUND;

Line 224: , P_REQUEST_ID => FND_API.G_MISS_NUM

220: , P_CREATED_BY => l_user_id
221: , P_LAST_UPDATED_BY => l_user_id
222: , P_LAST_UPDATE_DATE => sysdate
223: , P_LAST_UPDATE_LOGIN => 0
224: , P_REQUEST_ID => FND_API.G_MISS_NUM
225: , P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM
226: , P_PROGRAM_ID => FND_API.G_MISS_NUM
227: , P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE
228: );

Line 225: , P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM

221: , P_LAST_UPDATED_BY => l_user_id
222: , P_LAST_UPDATE_DATE => sysdate
223: , P_LAST_UPDATE_LOGIN => 0
224: , P_REQUEST_ID => FND_API.G_MISS_NUM
225: , P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM
226: , P_PROGRAM_ID => FND_API.G_MISS_NUM
227: , P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE
228: );
229: ELSE

Line 226: , P_PROGRAM_ID => FND_API.G_MISS_NUM

222: , P_LAST_UPDATE_DATE => sysdate
223: , P_LAST_UPDATE_LOGIN => 0
224: , P_REQUEST_ID => FND_API.G_MISS_NUM
225: , P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM
226: , P_PROGRAM_ID => FND_API.G_MISS_NUM
227: , P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE
228: );
229: ELSE
230: UPDATE_ROW (

Line 227: , P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE

223: , P_LAST_UPDATE_LOGIN => 0
224: , P_REQUEST_ID => FND_API.G_MISS_NUM
225: , P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM
226: , P_PROGRAM_ID => FND_API.G_MISS_NUM
227: , P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE
228: );
229: ELSE
230: UPDATE_ROW (
231: P_DEPENDENCY_ID => l_dependency_id

Line 243: , P_REQUEST_ID => FND_API.G_MISS_NUM

239: , P_CREATED_BY => l_user_id
240: , P_LAST_UPDATED_BY => l_user_id
241: , P_LAST_UPDATE_DATE => sysdate
242: , P_LAST_UPDATE_LOGIN => 0
243: , P_REQUEST_ID => FND_API.G_MISS_NUM
244: , P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM
245: , P_PROGRAM_ID => FND_API.G_MISS_NUM
246: , P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE
247: );

Line 244: , P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM

240: , P_LAST_UPDATED_BY => l_user_id
241: , P_LAST_UPDATE_DATE => sysdate
242: , P_LAST_UPDATE_LOGIN => 0
243: , P_REQUEST_ID => FND_API.G_MISS_NUM
244: , P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM
245: , P_PROGRAM_ID => FND_API.G_MISS_NUM
246: , P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE
247: );
248: END IF;

Line 245: , P_PROGRAM_ID => FND_API.G_MISS_NUM

241: , P_LAST_UPDATE_DATE => sysdate
242: , P_LAST_UPDATE_LOGIN => 0
243: , P_REQUEST_ID => FND_API.G_MISS_NUM
244: , P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM
245: , P_PROGRAM_ID => FND_API.G_MISS_NUM
246: , P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE
247: );
248: END IF;
249:

Line 246: , P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE

242: , P_LAST_UPDATE_LOGIN => 0
243: , P_REQUEST_ID => FND_API.G_MISS_NUM
244: , P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM
245: , P_PROGRAM_ID => FND_API.G_MISS_NUM
246: , P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE
247: );
248: END IF;
249:
250: CLOSE C;