[Home] [Help]
248:
249: PROCEDURE create_header IS
250: -- create a header record for the process.
251: BEGIN
252: INSERT INTO igs_ps_sch_hdr_int_all (
253: transaction_id ,
254: originator ,
255: request_date ,
256: org_id ,
1412: IF l_trans_id IS NOT NULL THEN
1413: OPEN c_pattern_int_exists(l_trans_id);
1414: FETCH c_pattern_int_exists INTO l_c_var;
1415: IF c_pattern_int_exists%NOTFOUND THEN
1416: DELETE IGS_PS_SCH_HDR_INT_ALL WHERE transaction_id = l_trans_id;
1417: l_data_found := FALSE;
1418: ELSE
1419: l_data_found := TRUE;
1420: --Update all the production records for the abort_flag='N'
2644: FOR UPDATE NOWAIT;
2645:
2646: CURSOR c_get_originator(p_transaction_id NUMBER) IS
2647: SELECT originator
2648: FROM igs_ps_sch_hdr_int_ALL
2649: WHERE transaction_id=p_transaction_id;
2650:
2651: CURSOR c_ipsuo(p_usec_id NUMBER) IS
2652: SELECT *
3084: tablenames_tbl(4) := 'IGS_PS_SCH_X_USEC_INT_ALL';
3085: tablenames_tbl(5) := 'IGS_PS_SCH_USEC_INT_ALL';
3086: tablenames_tbl(6) := 'IGS_PS_SCH_INT_ALL';
3087: tablenames_tbl(7) := 'IGS_PS_PREFS_SCH_INT_ALL';
3088: tablenames_tbl(8) := 'IGS_PS_SCH_HDR_INT_ALL';
3089:
3090: FOR i IN 1.. tablenames_tbl.LAST
3091: LOOP
3092: fnd_stats.gather_table_stats(ownname => l_c_schema,
4210: /********************** Purging the header Records***************************/
4211: FOR rec_header IN c_header LOOP
4212:
4213: -- Deleting transaction header record
4214: DELETE FROM igs_ps_sch_hdr_int_all WHERE transaction_id=rec_header.transaction_id;
4215:
4216: END LOOP;
4217:
4218: