497: NUM_COL3_ORIG_LIST(I) ,
498: NUM_COL3_NEW_LIST(I) ,
499: 'U' ,
500: req_id ,
501: hz_utility_pub.CREATED_BY ,
502: hz_utility_pub.CREATION_DATE ,
503: hz_utility_pub.LAST_UPDATE_LOGIN ,
504: hz_utility_pub.LAST_UPDATE_DATE ,
505: hz_utility_pub.LAST_UPDATED_BY
498: NUM_COL3_NEW_LIST(I) ,
499: 'U' ,
500: req_id ,
501: hz_utility_pub.CREATED_BY ,
502: hz_utility_pub.CREATION_DATE ,
503: hz_utility_pub.LAST_UPDATE_LOGIN ,
504: hz_utility_pub.LAST_UPDATE_DATE ,
505: hz_utility_pub.LAST_UPDATED_BY
506: );
499: 'U' ,
500: req_id ,
501: hz_utility_pub.CREATED_BY ,
502: hz_utility_pub.CREATION_DATE ,
503: hz_utility_pub.LAST_UPDATE_LOGIN ,
504: hz_utility_pub.LAST_UPDATE_DATE ,
505: hz_utility_pub.LAST_UPDATED_BY
506: );
507: END IF; -- } 7
500: req_id ,
501: hz_utility_pub.CREATED_BY ,
502: hz_utility_pub.CREATION_DATE ,
503: hz_utility_pub.LAST_UPDATE_LOGIN ,
504: hz_utility_pub.LAST_UPDATE_DATE ,
505: hz_utility_pub.LAST_UPDATED_BY
506: );
507: END IF; -- } 7
508:
501: hz_utility_pub.CREATED_BY ,
502: hz_utility_pub.CREATION_DATE ,
503: hz_utility_pub.LAST_UPDATE_LOGIN ,
504: hz_utility_pub.LAST_UPDATE_DATE ,
505: hz_utility_pub.LAST_UPDATED_BY
506: );
507: END IF; -- } 7
508:
509: csi_t_gen_utility_pvt.add('build the transaction record, if this is the first time');
1615: NUM_COL3_ORIG_LIST(I) ,
1616: NUM_COL3_NEW_LIST(I) ,
1617: 'U' ,
1618: req_id ,
1619: hz_utility_pub.CREATED_BY ,
1620: hz_utility_pub.CREATION_DATE ,
1621: hz_utility_pub.LAST_UPDATE_LOGIN ,
1622: hz_utility_pub.LAST_UPDATE_DATE ,
1623: hz_utility_pub.LAST_UPDATED_BY
1616: NUM_COL3_NEW_LIST(I) ,
1617: 'U' ,
1618: req_id ,
1619: hz_utility_pub.CREATED_BY ,
1620: hz_utility_pub.CREATION_DATE ,
1621: hz_utility_pub.LAST_UPDATE_LOGIN ,
1622: hz_utility_pub.LAST_UPDATE_DATE ,
1623: hz_utility_pub.LAST_UPDATED_BY
1624: );
1617: 'U' ,
1618: req_id ,
1619: hz_utility_pub.CREATED_BY ,
1620: hz_utility_pub.CREATION_DATE ,
1621: hz_utility_pub.LAST_UPDATE_LOGIN ,
1622: hz_utility_pub.LAST_UPDATE_DATE ,
1623: hz_utility_pub.LAST_UPDATED_BY
1624: );
1625:
1618: req_id ,
1619: hz_utility_pub.CREATED_BY ,
1620: hz_utility_pub.CREATION_DATE ,
1621: hz_utility_pub.LAST_UPDATE_LOGIN ,
1622: hz_utility_pub.LAST_UPDATE_DATE ,
1623: hz_utility_pub.LAST_UPDATED_BY
1624: );
1625:
1626: END IF; -- } profile value if
1619: hz_utility_pub.CREATED_BY ,
1620: hz_utility_pub.CREATION_DATE ,
1621: hz_utility_pub.LAST_UPDATE_LOGIN ,
1622: hz_utility_pub.LAST_UPDATE_DATE ,
1623: hz_utility_pub.LAST_UPDATED_BY
1624: );
1625:
1626: END IF; -- } profile value if
1627:
1989: NUM_COL3_ORIG_LIST(I) ,
1990: NUM_COL3_NEW_LIST(I) ,
1991: 'U' ,
1992: req_id ,
1993: hz_utility_pub.CREATED_BY ,
1994: hz_utility_pub.CREATION_DATE ,
1995: hz_utility_pub.LAST_UPDATE_LOGIN ,
1996: hz_utility_pub.LAST_UPDATE_DATE ,
1997: hz_utility_pub.LAST_UPDATED_BY
1990: NUM_COL3_NEW_LIST(I) ,
1991: 'U' ,
1992: req_id ,
1993: hz_utility_pub.CREATED_BY ,
1994: hz_utility_pub.CREATION_DATE ,
1995: hz_utility_pub.LAST_UPDATE_LOGIN ,
1996: hz_utility_pub.LAST_UPDATE_DATE ,
1997: hz_utility_pub.LAST_UPDATED_BY
1998: );
1991: 'U' ,
1992: req_id ,
1993: hz_utility_pub.CREATED_BY ,
1994: hz_utility_pub.CREATION_DATE ,
1995: hz_utility_pub.LAST_UPDATE_LOGIN ,
1996: hz_utility_pub.LAST_UPDATE_DATE ,
1997: hz_utility_pub.LAST_UPDATED_BY
1998: );
1999: END IF;
1992: req_id ,
1993: hz_utility_pub.CREATED_BY ,
1994: hz_utility_pub.CREATION_DATE ,
1995: hz_utility_pub.LAST_UPDATE_LOGIN ,
1996: hz_utility_pub.LAST_UPDATE_DATE ,
1997: hz_utility_pub.LAST_UPDATED_BY
1998: );
1999: END IF;
2000:
1993: hz_utility_pub.CREATED_BY ,
1994: hz_utility_pub.CREATION_DATE ,
1995: hz_utility_pub.LAST_UPDATE_LOGIN ,
1996: hz_utility_pub.LAST_UPDATE_DATE ,
1997: hz_utility_pub.LAST_UPDATED_BY
1998: );
1999: END IF;
2000:
2001: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2187: NUM_COL4_ORIG_LIST(I),
2188: NUM_COL4_NEW_LIST(I),
2189: 'U',
2190: req_id,
2191: hz_utility_pub.CREATED_BY,
2192: hz_utility_pub.CREATION_DATE,
2193: hz_utility_pub.LAST_UPDATE_LOGIN,
2194: hz_utility_pub.LAST_UPDATE_DATE,
2195: hz_utility_pub.LAST_UPDATED_BY );
2188: NUM_COL4_NEW_LIST(I),
2189: 'U',
2190: req_id,
2191: hz_utility_pub.CREATED_BY,
2192: hz_utility_pub.CREATION_DATE,
2193: hz_utility_pub.LAST_UPDATE_LOGIN,
2194: hz_utility_pub.LAST_UPDATE_DATE,
2195: hz_utility_pub.LAST_UPDATED_BY );
2196: END IF;
2189: 'U',
2190: req_id,
2191: hz_utility_pub.CREATED_BY,
2192: hz_utility_pub.CREATION_DATE,
2193: hz_utility_pub.LAST_UPDATE_LOGIN,
2194: hz_utility_pub.LAST_UPDATE_DATE,
2195: hz_utility_pub.LAST_UPDATED_BY );
2196: END IF;
2197:
2190: req_id,
2191: hz_utility_pub.CREATED_BY,
2192: hz_utility_pub.CREATION_DATE,
2193: hz_utility_pub.LAST_UPDATE_LOGIN,
2194: hz_utility_pub.LAST_UPDATE_DATE,
2195: hz_utility_pub.LAST_UPDATED_BY );
2196: END IF;
2197:
2198: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2191: hz_utility_pub.CREATED_BY,
2192: hz_utility_pub.CREATION_DATE,
2193: hz_utility_pub.LAST_UPDATE_LOGIN,
2194: hz_utility_pub.LAST_UPDATE_DATE,
2195: hz_utility_pub.LAST_UPDATED_BY );
2196: END IF;
2197:
2198: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2199: UPDATE CSI_T_TXN_SYSTEMS yt