DBA Data[Home] [Help]

APPS.PV_ENTITY_RULES_APPLIED_PKG dependencies on PV_ENTITY_RULES_APPLIED_S

Line 58: CURSOR C2 IS SELECT PV_ENTITY_RULES_APPLIED_S.nextval FROM sys.dual;

54: ,p_ATTRIBUTE15 VARCHAR2
55: ,p_PROCESS_STATUS VARCHAR2)
56:
57: IS
58: CURSOR C2 IS SELECT PV_ENTITY_RULES_APPLIED_S.nextval FROM sys.dual;
59: BEGIN
60: -- If (px_ENTITY_RULE_APPLIED_ID IS NULL) OR (px_ENTITY_RULE_APPLIED_ID = FND_API.G_MISS_NUM) then
61: -- OPEN C2;
62: -- FETCH C2 INTO px_ENTITY_RULE_APPLIED_ID;

Line 109: PV_ENTITY_RULES_APPLIED_S.nextval --px_ENTITY_RULE_APPLIED_ID

105: ,ATTRIBUTE14
106: ,ATTRIBUTE15
107: ,PROCESS_STATUS
108: ) VALUES (
109: PV_ENTITY_RULES_APPLIED_S.nextval --px_ENTITY_RULE_APPLIED_ID
110: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
111: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
112: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
113: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)