1193: cust_shipto_terms.EXCLUDE_NON_WORKDAYS_FLAG,
1194: cust_shipto_terms.DISABLE_CREATE_CUM_KEY_FLAG,
1195: 'D',
1196: req_id,
1197: hz_utility_pub.CREATED_BY,
1198: hz_utility_pub.CREATION_DATE,
1199: hz_utility_pub.LAST_UPDATE_LOGIN,
1200: hz_utility_pub.LAST_UPDATE_DATE,
1201: hz_utility_pub.LAST_UPDATED_BY);
1194: cust_shipto_terms.DISABLE_CREATE_CUM_KEY_FLAG,
1195: 'D',
1196: req_id,
1197: hz_utility_pub.CREATED_BY,
1198: hz_utility_pub.CREATION_DATE,
1199: hz_utility_pub.LAST_UPDATE_LOGIN,
1200: hz_utility_pub.LAST_UPDATE_DATE,
1201: hz_utility_pub.LAST_UPDATED_BY);
1202:
1195: 'D',
1196: req_id,
1197: hz_utility_pub.CREATED_BY,
1198: hz_utility_pub.CREATION_DATE,
1199: hz_utility_pub.LAST_UPDATE_LOGIN,
1200: hz_utility_pub.LAST_UPDATE_DATE,
1201: hz_utility_pub.LAST_UPDATED_BY);
1202:
1203: END LOOP;
1196: req_id,
1197: hz_utility_pub.CREATED_BY,
1198: hz_utility_pub.CREATION_DATE,
1199: hz_utility_pub.LAST_UPDATE_LOGIN,
1200: hz_utility_pub.LAST_UPDATE_DATE,
1201: hz_utility_pub.LAST_UPDATED_BY);
1202:
1203: END LOOP;
1204: --
1197: hz_utility_pub.CREATED_BY,
1198: hz_utility_pub.CREATION_DATE,
1199: hz_utility_pub.LAST_UPDATE_LOGIN,
1200: hz_utility_pub.LAST_UPDATE_DATE,
1201: hz_utility_pub.LAST_UPDATED_BY);
1202:
1203: END LOOP;
1204: --
1205: END LOOP;
1575: cust_item_terms.EXCLUDE_NON_WORKDAYS_FLAG,
1576: cust_item_terms.DISABLE_CREATE_CUM_KEY_FLAG,
1577: 'D',
1578: req_id,
1579: hz_utility_pub.CREATED_BY,
1580: hz_utility_pub.CREATION_DATE,
1581: hz_utility_pub.LAST_UPDATE_LOGIN,
1582: hz_utility_pub.LAST_UPDATE_DATE,
1583: hz_utility_pub.LAST_UPDATED_BY);
1576: cust_item_terms.DISABLE_CREATE_CUM_KEY_FLAG,
1577: 'D',
1578: req_id,
1579: hz_utility_pub.CREATED_BY,
1580: hz_utility_pub.CREATION_DATE,
1581: hz_utility_pub.LAST_UPDATE_LOGIN,
1582: hz_utility_pub.LAST_UPDATE_DATE,
1583: hz_utility_pub.LAST_UPDATED_BY);
1584: END LOOP;
1577: 'D',
1578: req_id,
1579: hz_utility_pub.CREATED_BY,
1580: hz_utility_pub.CREATION_DATE,
1581: hz_utility_pub.LAST_UPDATE_LOGIN,
1582: hz_utility_pub.LAST_UPDATE_DATE,
1583: hz_utility_pub.LAST_UPDATED_BY);
1584: END LOOP;
1585: --
1578: req_id,
1579: hz_utility_pub.CREATED_BY,
1580: hz_utility_pub.CREATION_DATE,
1581: hz_utility_pub.LAST_UPDATE_LOGIN,
1582: hz_utility_pub.LAST_UPDATE_DATE,
1583: hz_utility_pub.LAST_UPDATED_BY);
1584: END LOOP;
1585: --
1586: END LOOP;
1579: hz_utility_pub.CREATED_BY,
1580: hz_utility_pub.CREATION_DATE,
1581: hz_utility_pub.LAST_UPDATE_LOGIN,
1582: hz_utility_pub.LAST_UPDATE_DATE,
1583: hz_utility_pub.LAST_UPDATED_BY);
1584: END LOOP;
1585: --
1586: END LOOP;
1587: --
1958: VCHAR_COL2_ORIG_LIST(I),
1959: VCHAR_COL2_NEW_LIST(I),
1960: 'U',
1961: req_id,
1962: hz_utility_pub.CREATED_BY,
1963: hz_utility_pub.CREATION_DATE,
1964: hz_utility_pub.LAST_UPDATE_LOGIN,
1965: hz_utility_pub.LAST_UPDATE_DATE,
1966: hz_utility_pub.LAST_UPDATED_BY
1959: VCHAR_COL2_NEW_LIST(I),
1960: 'U',
1961: req_id,
1962: hz_utility_pub.CREATED_BY,
1963: hz_utility_pub.CREATION_DATE,
1964: hz_utility_pub.LAST_UPDATE_LOGIN,
1965: hz_utility_pub.LAST_UPDATE_DATE,
1966: hz_utility_pub.LAST_UPDATED_BY
1967: );
1960: 'U',
1961: req_id,
1962: hz_utility_pub.CREATED_BY,
1963: hz_utility_pub.CREATION_DATE,
1964: hz_utility_pub.LAST_UPDATE_LOGIN,
1965: hz_utility_pub.LAST_UPDATE_DATE,
1966: hz_utility_pub.LAST_UPDATED_BY
1967: );
1968:
1961: req_id,
1962: hz_utility_pub.CREATED_BY,
1963: hz_utility_pub.CREATION_DATE,
1964: hz_utility_pub.LAST_UPDATE_LOGIN,
1965: hz_utility_pub.LAST_UPDATE_DATE,
1966: hz_utility_pub.LAST_UPDATED_BY
1967: );
1968:
1969: END IF;
1962: hz_utility_pub.CREATED_BY,
1963: hz_utility_pub.CREATION_DATE,
1964: hz_utility_pub.LAST_UPDATE_LOGIN,
1965: hz_utility_pub.LAST_UPDATE_DATE,
1966: hz_utility_pub.LAST_UPDATED_BY
1967: );
1968:
1969: END IF;
1970: IF l_last_fetch THEN
2107: VCHAR_COL2_ORIG_LIST(I),
2108: VCHAR_COL2_NEW_LIST(I),
2109: 'U',
2110: req_id,
2111: hz_utility_pub.CREATED_BY,
2112: hz_utility_pub.CREATION_DATE,
2113: hz_utility_pub.LAST_UPDATE_LOGIN,
2114: hz_utility_pub.LAST_UPDATE_DATE,
2115: hz_utility_pub.LAST_UPDATED_BY
2108: VCHAR_COL2_NEW_LIST(I),
2109: 'U',
2110: req_id,
2111: hz_utility_pub.CREATED_BY,
2112: hz_utility_pub.CREATION_DATE,
2113: hz_utility_pub.LAST_UPDATE_LOGIN,
2114: hz_utility_pub.LAST_UPDATE_DATE,
2115: hz_utility_pub.LAST_UPDATED_BY
2116: );
2109: 'U',
2110: req_id,
2111: hz_utility_pub.CREATED_BY,
2112: hz_utility_pub.CREATION_DATE,
2113: hz_utility_pub.LAST_UPDATE_LOGIN,
2114: hz_utility_pub.LAST_UPDATE_DATE,
2115: hz_utility_pub.LAST_UPDATED_BY
2116: );
2117:
2110: req_id,
2111: hz_utility_pub.CREATED_BY,
2112: hz_utility_pub.CREATION_DATE,
2113: hz_utility_pub.LAST_UPDATE_LOGIN,
2114: hz_utility_pub.LAST_UPDATE_DATE,
2115: hz_utility_pub.LAST_UPDATED_BY
2116: );
2117:
2118: END IF;
2111: hz_utility_pub.CREATED_BY,
2112: hz_utility_pub.CREATION_DATE,
2113: hz_utility_pub.LAST_UPDATE_LOGIN,
2114: hz_utility_pub.LAST_UPDATE_DATE,
2115: hz_utility_pub.LAST_UPDATED_BY
2116: );
2117:
2118: END IF;
2119: IF l_last_fetch THEN
2297: VCHAR_COL1_ORIG_LIST(I),
2298: VCHAR_COL1_NEW_LIST(I),
2299: 'U',
2300: req_id,
2301: hz_utility_pub.CREATED_BY,
2302: hz_utility_pub.CREATION_DATE,
2303: hz_utility_pub.LAST_UPDATE_LOGIN,
2304: hz_utility_pub.LAST_UPDATE_DATE,
2305: hz_utility_pub.LAST_UPDATED_BY
2298: VCHAR_COL1_NEW_LIST(I),
2299: 'U',
2300: req_id,
2301: hz_utility_pub.CREATED_BY,
2302: hz_utility_pub.CREATION_DATE,
2303: hz_utility_pub.LAST_UPDATE_LOGIN,
2304: hz_utility_pub.LAST_UPDATE_DATE,
2305: hz_utility_pub.LAST_UPDATED_BY
2306: );
2299: 'U',
2300: req_id,
2301: hz_utility_pub.CREATED_BY,
2302: hz_utility_pub.CREATION_DATE,
2303: hz_utility_pub.LAST_UPDATE_LOGIN,
2304: hz_utility_pub.LAST_UPDATE_DATE,
2305: hz_utility_pub.LAST_UPDATED_BY
2306: );
2307:
2300: req_id,
2301: hz_utility_pub.CREATED_BY,
2302: hz_utility_pub.CREATION_DATE,
2303: hz_utility_pub.LAST_UPDATE_LOGIN,
2304: hz_utility_pub.LAST_UPDATE_DATE,
2305: hz_utility_pub.LAST_UPDATED_BY
2306: );
2307:
2308: END IF;
2301: hz_utility_pub.CREATED_BY,
2302: hz_utility_pub.CREATION_DATE,
2303: hz_utility_pub.LAST_UPDATE_LOGIN,
2304: hz_utility_pub.LAST_UPDATE_DATE,
2305: hz_utility_pub.LAST_UPDATED_BY
2306: );
2307:
2308: END IF;
2309: IF l_last_fetch THEN
2446: VCHAR_COL2_ORIG_LIST(I),
2447: VCHAR_COL2_NEW_LIST(I),
2448: 'U',
2449: req_id,
2450: hz_utility_pub.CREATED_BY,
2451: hz_utility_pub.CREATION_DATE,
2452: hz_utility_pub.LAST_UPDATE_LOGIN,
2453: hz_utility_pub.LAST_UPDATE_DATE,
2454: hz_utility_pub.LAST_UPDATED_BY
2447: VCHAR_COL2_NEW_LIST(I),
2448: 'U',
2449: req_id,
2450: hz_utility_pub.CREATED_BY,
2451: hz_utility_pub.CREATION_DATE,
2452: hz_utility_pub.LAST_UPDATE_LOGIN,
2453: hz_utility_pub.LAST_UPDATE_DATE,
2454: hz_utility_pub.LAST_UPDATED_BY
2455: );
2448: 'U',
2449: req_id,
2450: hz_utility_pub.CREATED_BY,
2451: hz_utility_pub.CREATION_DATE,
2452: hz_utility_pub.LAST_UPDATE_LOGIN,
2453: hz_utility_pub.LAST_UPDATE_DATE,
2454: hz_utility_pub.LAST_UPDATED_BY
2455: );
2456:
2449: req_id,
2450: hz_utility_pub.CREATED_BY,
2451: hz_utility_pub.CREATION_DATE,
2452: hz_utility_pub.LAST_UPDATE_LOGIN,
2453: hz_utility_pub.LAST_UPDATE_DATE,
2454: hz_utility_pub.LAST_UPDATED_BY
2455: );
2456:
2457: END IF;
2450: hz_utility_pub.CREATED_BY,
2451: hz_utility_pub.CREATION_DATE,
2452: hz_utility_pub.LAST_UPDATE_LOGIN,
2453: hz_utility_pub.LAST_UPDATE_DATE,
2454: hz_utility_pub.LAST_UPDATED_BY
2455: );
2456:
2457: END IF;
2458: IF l_last_fetch THEN
2637: VCHAR_COL1_ORIG_LIST(I),
2638: VCHAR_COL1_NEW_LIST(I),
2639: 'U',
2640: req_id,
2641: hz_utility_pub.CREATED_BY,
2642: hz_utility_pub.CREATION_DATE,
2643: hz_utility_pub.LAST_UPDATE_LOGIN,
2644: hz_utility_pub.LAST_UPDATE_DATE,
2645: hz_utility_pub.LAST_UPDATED_BY
2638: VCHAR_COL1_NEW_LIST(I),
2639: 'U',
2640: req_id,
2641: hz_utility_pub.CREATED_BY,
2642: hz_utility_pub.CREATION_DATE,
2643: hz_utility_pub.LAST_UPDATE_LOGIN,
2644: hz_utility_pub.LAST_UPDATE_DATE,
2645: hz_utility_pub.LAST_UPDATED_BY
2646: );
2639: 'U',
2640: req_id,
2641: hz_utility_pub.CREATED_BY,
2642: hz_utility_pub.CREATION_DATE,
2643: hz_utility_pub.LAST_UPDATE_LOGIN,
2644: hz_utility_pub.LAST_UPDATE_DATE,
2645: hz_utility_pub.LAST_UPDATED_BY
2646: );
2647:
2640: req_id,
2641: hz_utility_pub.CREATED_BY,
2642: hz_utility_pub.CREATION_DATE,
2643: hz_utility_pub.LAST_UPDATE_LOGIN,
2644: hz_utility_pub.LAST_UPDATE_DATE,
2645: hz_utility_pub.LAST_UPDATED_BY
2646: );
2647:
2648: END IF;
2641: hz_utility_pub.CREATED_BY,
2642: hz_utility_pub.CREATION_DATE,
2643: hz_utility_pub.LAST_UPDATE_LOGIN,
2644: hz_utility_pub.LAST_UPDATE_DATE,
2645: hz_utility_pub.LAST_UPDATED_BY
2646: );
2647:
2648: END IF;
2649: IF l_last_fetch THEN