APPS.WIP_FLOW_CHARGE_UTILITIES dependencies on WIP_COST_TXN_INTERFACE

Line 16: INSERT INTO WIP_COST_TXN_INTERFACE

12: p_rtg_rev_date in varchar2) return number is
13:
14: BEGIN
15:
16: INSERT INTO WIP_COST_TXN_INTERFACE
17: (transaction_id,
18: last_update_date,
19: last_updated_by,
20: last_updated_by_name,

Line 254: UPDATE WIP_COST_TXN_INTERFACE

250: MP.ORGANIZATION_CODE;
251:
252: -- Taking care of the Activity update in two stages
253: -- as we have an index on completion_txn_id
254: UPDATE WIP_COST_TXN_INTERFACE
255: SET ACTIVITY_ID = DECODE(ACTIVITY_ID,
256: -1, NULL,
257: ACTIVITY_ID)
258: WHERE COMPLETION_TRANSACTION_ID = p_comp_txn_id;

Line 276: INSERT INTO WIP_COST_TXN_INTERFACE

272: p_rtg_rev_date in varchar2 ) return number is
273:
274: Begin
275:
276: INSERT INTO WIP_COST_TXN_INTERFACE
277: ( transaction_id,
278: last_update_date,
279: last_updated_by,
280: last_updated_by_name,

Line 446: INSERT INTO WIP_COST_TXN_INTERFACE

442: p_rtg_rev_date in varchar2 ) return number is
443:
444: Begin
445:
446: INSERT INTO WIP_COST_TXN_INTERFACE
447: ( transaction_id,
448: last_update_date,
449: last_updated_by,
450: last_updated_by_name,

Line 838: from WIP_COST_TXN_INTERFACE

834: /* Cursor for the rows that will fail validation */
835: CURSOR Failure_Cursor(p_group_id in number) is
836: Select
837: Transaction_id
838: from WIP_COST_TXN_INTERFACE
839: where group_id = p_group_id
840: and process_phase = 1; /* The Process Phase is 1 */
841: x_error_mesg varchar2(240);
842: begin

Line 850: Update WIP_COST_TXN_INTERFACE

846: x_error_mesg := fnd_message.get ;
847:
848: For fail_rec in Failure_Cursor(p_group_id) LOOP
849:
850: Update WIP_COST_TXN_INTERFACE
851: set PROCESS_STATUS = 3 /* set the process_phase to error */
852: where transaction_id = fail_rec.transaction_id ;
853:
854: Insert into WIP_TXN_INTERFACE_ERRORS

Line 880: from WIP_COST_TXN_INTERFACE

876: request_id,
877: program_application_id,
878: program_id,
879: SYSDATE
880: from WIP_COST_TXN_INTERFACE
881: where transaction_id = fail_rec.transaction_id ;
882:
883: end LOOP ;
884: