DBA Data[Home] [Help]

APPS.OE_PC_CONDITIONS_PKG dependencies on OE_PC_CONDITIONS_S

Line 336: update OE_PC_CONDITIONS set

332: X_LAST_UPDATE_LOGIN in NUMBER
333: ) is
334: begin
335:
336: update OE_PC_CONDITIONS set
337: CONSTRAINT_ID = X_CONSTRAINT_ID,
338: GROUP_NUMBER = X_GROUP_NUMBER,
339: SYSTEM_FLAG = X_SYSTEM_FLAG,
340: MODIFIER_FLAG = X_MODIFIER_FLAG,

Line 523: CURSOR CID IS SELECT oe_pc_conditions_s.nextval from dual;

519: X_START_DATE_ACTIVE in VARCHAR2,
520: X_END_DATE_ACTIVE in VARCHAR2,
521: X_ENABLED_FLAG in VARCHAR2 DEFAULT NULL
522: ) is
523: CURSOR CID IS SELECT oe_pc_conditions_s.nextval from dual;
524: begin
525:
526: declare
527: user_id number := 0;