eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_IMP_AC_KRS dependencies on CZ_IMP_CUSTOMER

Line 27: nOnlcustomerId CZ_IMP_CUSTOMER.CUSTOMER_ID%TYPE;

23: x_onl_customer_customerid_f BOOLEAN:=FALSE;
24: x_onl_address_addressid_f BOOLEAN:=FALSE;
25: x_error BOOLEAN:=FALSE;
26: nOnlContactId CZ_IMP_CONTACT.CONTACT_ID%TYPE;
27: nOnlcustomerId CZ_IMP_CUSTOMER.CUSTOMER_ID%TYPE;
28: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
29: sImpOrigSysRef CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
30: sFSKcustomer CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
31: sFSKaddress CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;

Line 222: FROM CZ_IMP_CUSTOMER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1,2,3, ROWID;

218: BEGIN
219: DECLARE
220: CURSOR c_imp_customer (x_usesurr_pricegroup PLS_INTEGER) IS
221: SELECT ORIG_SYS_REF, DECODE(x_usesurr_pricegroup,0,FSK_PRICEGROUP_1_1,1,FSK_PRICEGROUP_1_EXT) ,FSK_CUSTOMER_2_1, ROWID
222: FROM CZ_IMP_CUSTOMER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1,2,3, ROWID;
223:
224: /* cursor's data found indicator */
225: x_imp_customer_f BOOLEAN:=FALSE;
226: x_onl_customer_f BOOLEAN:=FALSE;

Line 230: nOnlcustomerId CZ_IMP_CUSTOMER.CUSTOMER_ID%TYPE;

226: x_onl_customer_f BOOLEAN:=FALSE;
227: x_onl_pricegroup_prgrpid_f BOOLEAN:=FALSE;
228: x_onl_customer_parentid_f BOOLEAN:=FALSE;
229: x_error BOOLEAN:=FALSE;
230: nOnlcustomerId CZ_IMP_CUSTOMER.CUSTOMER_ID%TYPE;
231: nOnlFskParentId CZ_IMP_CUSTOMER.PARENT_ID%TYPE;
232: nOnlFSKPriceGroupId CZ_IMP_CUSTOMER.PRICE_list_ID%TYPE;
233: sImpOrigsysref CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
234: sFSKPRICEGROUP CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;

Line 231: nOnlFskParentId CZ_IMP_CUSTOMER.PARENT_ID%TYPE;

227: x_onl_pricegroup_prgrpid_f BOOLEAN:=FALSE;
228: x_onl_customer_parentid_f BOOLEAN:=FALSE;
229: x_error BOOLEAN:=FALSE;
230: nOnlcustomerId CZ_IMP_CUSTOMER.CUSTOMER_ID%TYPE;
231: nOnlFskParentId CZ_IMP_CUSTOMER.PARENT_ID%TYPE;
232: nOnlFSKPriceGroupId CZ_IMP_CUSTOMER.PRICE_list_ID%TYPE;
233: sImpOrigsysref CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
234: sFSKPRICEGROUP CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
235: sFSKCUSTOMER CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;

Line 232: nOnlFSKPriceGroupId CZ_IMP_CUSTOMER.PRICE_list_ID%TYPE;

228: x_onl_customer_parentid_f BOOLEAN:=FALSE;
229: x_error BOOLEAN:=FALSE;
230: nOnlcustomerId CZ_IMP_CUSTOMER.CUSTOMER_ID%TYPE;
231: nOnlFskParentId CZ_IMP_CUSTOMER.PARENT_ID%TYPE;
232: nOnlFSKPriceGroupId CZ_IMP_CUSTOMER.PRICE_list_ID%TYPE;
233: sImpOrigsysref CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
234: sFSKPRICEGROUP CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
235: sFSKCUSTOMER CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
236: sLastFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;

Line 233: sImpOrigsysref CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;

229: x_error BOOLEAN:=FALSE;
230: nOnlcustomerId CZ_IMP_CUSTOMER.CUSTOMER_ID%TYPE;
231: nOnlFskParentId CZ_IMP_CUSTOMER.PARENT_ID%TYPE;
232: nOnlFSKPriceGroupId CZ_IMP_CUSTOMER.PRICE_list_ID%TYPE;
233: sImpOrigsysref CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
234: sFSKPRICEGROUP CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
235: sFSKCUSTOMER CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
236: sLastFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
237: sThisFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;

Line 234: sFSKPRICEGROUP CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;

230: nOnlcustomerId CZ_IMP_CUSTOMER.CUSTOMER_ID%TYPE;
231: nOnlFskParentId CZ_IMP_CUSTOMER.PARENT_ID%TYPE;
232: nOnlFSKPriceGroupId CZ_IMP_CUSTOMER.PRICE_list_ID%TYPE;
233: sImpOrigsysref CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
234: sFSKPRICEGROUP CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
235: sFSKCUSTOMER CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
236: sLastFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
237: sThisFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
238: sLastFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;

Line 235: sFSKCUSTOMER CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;

231: nOnlFskParentId CZ_IMP_CUSTOMER.PARENT_ID%TYPE;
232: nOnlFSKPriceGroupId CZ_IMP_CUSTOMER.PRICE_list_ID%TYPE;
233: sImpOrigsysref CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
234: sFSKPRICEGROUP CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
235: sFSKCUSTOMER CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
236: sLastFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
237: sThisFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
238: sLastFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
239: sThisFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;

Line 236: sLastFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;

232: nOnlFSKPriceGroupId CZ_IMP_CUSTOMER.PRICE_list_ID%TYPE;
233: sImpOrigsysref CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
234: sFSKPRICEGROUP CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
235: sFSKCUSTOMER CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
236: sLastFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
237: sThisFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
238: sLastFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
239: sThisFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
240: sLastFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;

Line 237: sThisFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;

233: sImpOrigsysref CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
234: sFSKPRICEGROUP CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
235: sFSKCUSTOMER CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
236: sLastFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
237: sThisFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
238: sLastFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
239: sThisFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
240: sLastFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
241: sThisFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;

Line 238: sLastFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;

234: sFSKPRICEGROUP CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
235: sFSKCUSTOMER CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
236: sLastFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
237: sThisFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
238: sLastFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
239: sThisFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
240: sLastFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
241: sThisFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
242: sRecStatus CZ_IMP_CUSTOMER.REC_STATUS%TYPE;

Line 239: sThisFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;

235: sFSKCUSTOMER CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
236: sLastFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
237: sThisFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
238: sLastFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
239: sThisFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
240: sLastFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
241: sThisFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
242: sRecStatus CZ_IMP_CUSTOMER.REC_STATUS%TYPE;
243: sDisposition CZ_IMP_CUSTOMER.DISPOSITION%TYPE;

Line 240: sLastFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;

236: sLastFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
237: sThisFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
238: sLastFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
239: sThisFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
240: sLastFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
241: sThisFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
242: sRecStatus CZ_IMP_CUSTOMER.REC_STATUS%TYPE;
243: sDisposition CZ_IMP_CUSTOMER.DISPOSITION%TYPE;
244: /* Internal vars */

Line 241: sThisFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;

237: sThisFSK1 CZ_IMP_CUSTOMER.ORIG_SYS_REF%TYPE;
238: sLastFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
239: sThisFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
240: sLastFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
241: sThisFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
242: sRecStatus CZ_IMP_CUSTOMER.REC_STATUS%TYPE;
243: sDisposition CZ_IMP_CUSTOMER.DISPOSITION%TYPE;
244: /* Internal vars */
245: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

Line 242: sRecStatus CZ_IMP_CUSTOMER.REC_STATUS%TYPE;

238: sLastFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
239: sThisFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
240: sLastFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
241: sThisFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
242: sRecStatus CZ_IMP_CUSTOMER.REC_STATUS%TYPE;
243: sDisposition CZ_IMP_CUSTOMER.DISPOSITION%TYPE;
244: /* Internal vars */
245: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
246: nErrorCount PLS_INTEGER:=0; /*Error index */

Line 243: sDisposition CZ_IMP_CUSTOMER.DISPOSITION%TYPE;

239: sThisFSK2 CZ_IMP_CUSTOMER.FSK_PRICEGROUP_1_1%TYPE;
240: sLastFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
241: sThisFSK3 CZ_IMP_CUSTOMER.FSK_CUSTOMER_2_1%TYPE;
242: sRecStatus CZ_IMP_CUSTOMER.REC_STATUS%TYPE;
243: sDisposition CZ_IMP_CUSTOMER.DISPOSITION%TYPE;
244: /* Internal vars */
245: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
246: nErrorCount PLS_INTEGER:=0; /*Error index */
247: nInsertCount PLS_INTEGER:=0; /*Inserts */

Line 386: UPDATE CZ_IMP_CUSTOMER SET CUSTOMER_ID=DECODE(sDISPOSITION,'R',CUSTOMER_ID,'I',nNextValue+nAllocateCounter,nonlCUSTOMERid),

382: END IF;
383: END;
384: END IF;
385:
386: UPDATE CZ_IMP_CUSTOMER SET CUSTOMER_ID=DECODE(sDISPOSITION,'R',CUSTOMER_ID,'I',nNextValue+nAllocateCounter,nonlCUSTOMERid),
387: PRICE_LIST_ID=DECODE(sDISPOSITION,'R',PRICE_list_ID,nOnlFSKPriceGroupId),
388: PARENT_ID=DECODE(sDISPOSITION,'R',PARENT_ID,nonlFSKParentid),
389: DISPOSITION=sDisposition, REC_STATUS=sRecStatus WHERE ROWID = thisRowId;
390: sLastFSK1:=sImpOrigSysref;

Line 764: SELECT FSK_CUSTOMER_1_1,DECODE(x_usesurr_enduser,0,FSK_ENDUSER_2_1,1,FSK_ENDUSER_2_EXT), ROWID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1,2, ROWID;

760: ) IS
761: BEGIN
762: DECLARE
763: CURSOR c_imp_CUSTOMERenduser(x_usesurr_enduser PLS_INTEGER) IS
764: SELECT FSK_CUSTOMER_1_1,DECODE(x_usesurr_enduser,0,FSK_ENDUSER_2_1,1,FSK_ENDUSER_2_EXT), ROWID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1,2, ROWID;
765: /* cursor's data found indicators */
766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;

Line 766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;

762: DECLARE
763: CURSOR c_imp_CUSTOMERenduser(x_usesurr_enduser PLS_INTEGER) IS
764: SELECT FSK_CUSTOMER_1_1,DECODE(x_usesurr_enduser,0,FSK_ENDUSER_2_1,1,FSK_ENDUSER_2_EXT), ROWID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1,2, ROWID;
765: /* cursor's data found indicators */
766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;

Line 767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;

763: CURSOR c_imp_CUSTOMERenduser(x_usesurr_enduser PLS_INTEGER) IS
764: SELECT FSK_CUSTOMER_1_1,DECODE(x_usesurr_enduser,0,FSK_ENDUSER_2_1,1,FSK_ENDUSER_2_EXT), ROWID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1,2, ROWID;
765: /* cursor's data found indicators */
766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;

Line 768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;

764: SELECT FSK_CUSTOMER_1_1,DECODE(x_usesurr_enduser,0,FSK_ENDUSER_2_1,1,FSK_ENDUSER_2_EXT), ROWID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1,2, ROWID;
765: /* cursor's data found indicators */
766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;

Line 769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;

765: /* cursor's data found indicators */
766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;

Line 770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;

766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;

Line 771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;

767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;
775: sDisposition CZ_IMP_CUSTOMER_END_USER.DISPOSITION%TYPE;

Line 772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;

768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;
775: sDisposition CZ_IMP_CUSTOMER_END_USER.DISPOSITION%TYPE;
776: /* Column Vars */

Line 773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;

769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;
775: sDisposition CZ_IMP_CUSTOMER_END_USER.DISPOSITION%TYPE;
776: /* Column Vars */
777: x_imp_CUSTOMERenduser_f BOOLEAN:=FALSE;

Line 774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;

770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;
775: sDisposition CZ_IMP_CUSTOMER_END_USER.DISPOSITION%TYPE;
776: /* Column Vars */
777: x_imp_CUSTOMERenduser_f BOOLEAN:=FALSE;
778: x_onl_CUSTOMER_CUSTOMERid_f BOOLEAN:=FALSE;

Line 775: sDisposition CZ_IMP_CUSTOMER_END_USER.DISPOSITION%TYPE;

771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;
775: sDisposition CZ_IMP_CUSTOMER_END_USER.DISPOSITION%TYPE;
776: /* Column Vars */
777: x_imp_CUSTOMERenduser_f BOOLEAN:=FALSE;
778: x_onl_CUSTOMER_CUSTOMERid_f BOOLEAN:=FALSE;
779: x_onl_enduser_enduserid_f BOOLEAN:=FALSE;

Line 896: UPDATE CZ_IMP_CUSTOMER_END_USER

892: END IF;
893: END;
894: END IF;
895:
896: UPDATE CZ_IMP_CUSTOMER_END_USER
897: SET CUSTOMER_ID=DECODE(sDISPOSITION,'R',CUSTOMER_ID,nOnlCUSTOMERId),
898: END_USER_ID=DECODE(sDISPOSITION,'R',END_USER_ID,nOnlendUserId),
899: DISPOSITION=sDisposition, REC_STATUS=sRecStatus
900: WHERE ROWID = thisRowId;