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_PR_KRS dependencies on CZ_IMP_PRICE

Line 16: nOnlFSKItemId CZ_IMP_PRICE.ITEM_ID%TYPE;

12: ) IS
13: BEGIN
14: DECLARE
15: /* cursor's data found indicators */
16: nOnlFSKItemId CZ_IMP_PRICE.ITEM_ID%TYPE;
17: nOnlFSKPriceGroupId CZ_IMP_PRICE.PRICE_GROUP_ID%TYPE;
18: sFSKITEMMASTER CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
19: sFSKPRICEGROUP CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
20: sLastFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;

Line 17: nOnlFSKPriceGroupId CZ_IMP_PRICE.PRICE_GROUP_ID%TYPE;

13: BEGIN
14: DECLARE
15: /* cursor's data found indicators */
16: nOnlFSKItemId CZ_IMP_PRICE.ITEM_ID%TYPE;
17: nOnlFSKPriceGroupId CZ_IMP_PRICE.PRICE_GROUP_ID%TYPE;
18: sFSKITEMMASTER CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
19: sFSKPRICEGROUP CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
20: sLastFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
21: sThisFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;

Line 18: sFSKITEMMASTER CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;

14: DECLARE
15: /* cursor's data found indicators */
16: nOnlFSKItemId CZ_IMP_PRICE.ITEM_ID%TYPE;
17: nOnlFSKPriceGroupId CZ_IMP_PRICE.PRICE_GROUP_ID%TYPE;
18: sFSKITEMMASTER CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
19: sFSKPRICEGROUP CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
20: sLastFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
21: sThisFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
22: sLastFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;

Line 19: sFSKPRICEGROUP CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;

15: /* cursor's data found indicators */
16: nOnlFSKItemId CZ_IMP_PRICE.ITEM_ID%TYPE;
17: nOnlFSKPriceGroupId CZ_IMP_PRICE.PRICE_GROUP_ID%TYPE;
18: sFSKITEMMASTER CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
19: sFSKPRICEGROUP CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
20: sLastFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
21: sThisFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
22: sLastFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
23: sThisFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;

Line 20: sLastFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;

16: nOnlFSKItemId CZ_IMP_PRICE.ITEM_ID%TYPE;
17: nOnlFSKPriceGroupId CZ_IMP_PRICE.PRICE_GROUP_ID%TYPE;
18: sFSKITEMMASTER CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
19: sFSKPRICEGROUP CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
20: sLastFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
21: sThisFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
22: sLastFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
23: sThisFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
24: sRecStatus CZ_IMP_PRICE.REC_STATUS%TYPE;

Line 21: sThisFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;

17: nOnlFSKPriceGroupId CZ_IMP_PRICE.PRICE_GROUP_ID%TYPE;
18: sFSKITEMMASTER CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
19: sFSKPRICEGROUP CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
20: sLastFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
21: sThisFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
22: sLastFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
23: sThisFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
24: sRecStatus CZ_IMP_PRICE.REC_STATUS%TYPE;
25: sDisposition CZ_IMP_PRICE.DISPOSITION%TYPE;

Line 22: sLastFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;

18: sFSKITEMMASTER CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
19: sFSKPRICEGROUP CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
20: sLastFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
21: sThisFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
22: sLastFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
23: sThisFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
24: sRecStatus CZ_IMP_PRICE.REC_STATUS%TYPE;
25: sDisposition CZ_IMP_PRICE.DISPOSITION%TYPE;
26: /* Column Vars */

Line 23: sThisFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;

19: sFSKPRICEGROUP CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
20: sLastFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
21: sThisFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
22: sLastFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
23: sThisFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
24: sRecStatus CZ_IMP_PRICE.REC_STATUS%TYPE;
25: sDisposition CZ_IMP_PRICE.DISPOSITION%TYPE;
26: /* Column Vars */
27: x_imp_price_f BOOLEAN:=FALSE;

Line 24: sRecStatus CZ_IMP_PRICE.REC_STATUS%TYPE;

20: sLastFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
21: sThisFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
22: sLastFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
23: sThisFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
24: sRecStatus CZ_IMP_PRICE.REC_STATUS%TYPE;
25: sDisposition CZ_IMP_PRICE.DISPOSITION%TYPE;
26: /* Column Vars */
27: x_imp_price_f BOOLEAN:=FALSE;
28: x_onl_price_f BOOLEAN:=FALSE;

Line 25: sDisposition CZ_IMP_PRICE.DISPOSITION%TYPE;

21: sThisFSK1 CZ_IMP_PRICE.FSK_ITEMMASTER_1_1%TYPE;
22: sLastFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
23: sThisFSK2 CZ_IMP_PRICE.FSK_PRICEGROUP_2_1%TYPE;
24: sRecStatus CZ_IMP_PRICE.REC_STATUS%TYPE;
25: sDisposition CZ_IMP_PRICE.DISPOSITION%TYPE;
26: /* Column Vars */
27: x_imp_price_f BOOLEAN:=FALSE;
28: x_onl_price_f BOOLEAN:=FALSE;
29: x_onl_itemmaster_itemid_f BOOLEAN:=FALSE;

Line 51: FROM CZ_IMP_PRICE

47: CURSOR C_IMP_PRICE(x_usesurr_itemmaster PLS_INTEGER,
48: x_usesurr_pricegroup PLS_INTEGER) IS
49: SELECT DECODE(x_usesurr_itemmaster,0,FSK_ITEMMASTER_1_1,1,FSK_ITEMMASTER_1_EXT),
50: DECODE(x_usesurr_pricegroup,0,FSK_PRICEGROUP_2_1,1,FSK_PRICEGROUP_2_EXT), ROWID
51: FROM CZ_IMP_PRICE
52: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
53: ORDER BY 1,2,ROWID;
54: BEGIN
55: OPEN C_IMP_PRICE(x_usesurr_itemmaster,x_usesurr_pricegroup);

Line 163: UPDATE CZ_IMP_PRICE

159: END IF;
160: END;
161: END IF;
162:
163: UPDATE CZ_IMP_PRICE
164: set ITEM_ID=DECODE(sDISPOSITION,'R',ITEM_ID,nOnlFSKItemId),
165: PRICE_GROUP_ID=DECODE(sDISPOSITION,'R',PRICE_GROUP_ID,nOnlFSKPriceGroupId),
166: DISPOSITION=sDisposition, REC_STATUS=sRecStatus
167: WHERE ROWID = thisRowId;

Line 203: sOrigSysRef CZ_IMP_PRICE_GROUP.NAME%TYPE;

199: ) IS
200: BEGIN
201: DECLARE
202: /* cursor's data found indicators */
203: sOrigSysRef CZ_IMP_PRICE_GROUP.NAME%TYPE;
204: nPriceGroupId CZ_IMP_PRICE_GROUP.PRICE_GROUP_ID%TYPE;
205: sLastFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;
206: sThisFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;
207: sRecStatus CZ_IMP_PRICE_GROUP.REC_STATUS%TYPE;

Line 204: nPriceGroupId CZ_IMP_PRICE_GROUP.PRICE_GROUP_ID%TYPE;

200: BEGIN
201: DECLARE
202: /* cursor's data found indicators */
203: sOrigSysRef CZ_IMP_PRICE_GROUP.NAME%TYPE;
204: nPriceGroupId CZ_IMP_PRICE_GROUP.PRICE_GROUP_ID%TYPE;
205: sLastFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;
206: sThisFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;
207: sRecStatus CZ_IMP_PRICE_GROUP.REC_STATUS%TYPE;
208: sDisposition CZ_IMP_PRICE_GROUP.DISPOSITION%TYPE;

Line 205: sLastFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;

201: DECLARE
202: /* cursor's data found indicators */
203: sOrigSysRef CZ_IMP_PRICE_GROUP.NAME%TYPE;
204: nPriceGroupId CZ_IMP_PRICE_GROUP.PRICE_GROUP_ID%TYPE;
205: sLastFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;
206: sThisFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;
207: sRecStatus CZ_IMP_PRICE_GROUP.REC_STATUS%TYPE;
208: sDisposition CZ_IMP_PRICE_GROUP.DISPOSITION%TYPE;
209: /* Column Vars */

Line 206: sThisFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;

202: /* cursor's data found indicators */
203: sOrigSysRef CZ_IMP_PRICE_GROUP.NAME%TYPE;
204: nPriceGroupId CZ_IMP_PRICE_GROUP.PRICE_GROUP_ID%TYPE;
205: sLastFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;
206: sThisFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;
207: sRecStatus CZ_IMP_PRICE_GROUP.REC_STATUS%TYPE;
208: sDisposition CZ_IMP_PRICE_GROUP.DISPOSITION%TYPE;
209: /* Column Vars */
210: x_imp_pricegroup_f BOOLEAN:=FALSE;

Line 207: sRecStatus CZ_IMP_PRICE_GROUP.REC_STATUS%TYPE;

203: sOrigSysRef CZ_IMP_PRICE_GROUP.NAME%TYPE;
204: nPriceGroupId CZ_IMP_PRICE_GROUP.PRICE_GROUP_ID%TYPE;
205: sLastFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;
206: sThisFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;
207: sRecStatus CZ_IMP_PRICE_GROUP.REC_STATUS%TYPE;
208: sDisposition CZ_IMP_PRICE_GROUP.DISPOSITION%TYPE;
209: /* Column Vars */
210: x_imp_pricegroup_f BOOLEAN:=FALSE;
211: x_onl_pricegroup_prcgrpid_f BOOLEAN:=FALSE;

Line 208: sDisposition CZ_IMP_PRICE_GROUP.DISPOSITION%TYPE;

204: nPriceGroupId CZ_IMP_PRICE_GROUP.PRICE_GROUP_ID%TYPE;
205: sLastFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;
206: sThisFSK CZ_IMP_PRICE_GROUP.NAME%TYPE;
207: sRecStatus CZ_IMP_PRICE_GROUP.REC_STATUS%TYPE;
208: sDisposition CZ_IMP_PRICE_GROUP.DISPOSITION%TYPE;
209: /* Column Vars */
210: x_imp_pricegroup_f BOOLEAN:=FALSE;
211: x_onl_pricegroup_prcgrpid_f BOOLEAN:=FALSE;
212: x_error BOOLEAN:=FALSE;

Line 227: SELECT ORIG_SYS_REF, ROWID FROM CZ_IMP_PRICE_GROUP

223: thisRowId ROWID;
224:
225: BEGIN
226: DECLARE CURSOR C_IMP_PRICEGROUP IS
227: SELECT ORIG_SYS_REF, ROWID FROM CZ_IMP_PRICE_GROUP
228: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
229: ORDER BY 1,ROWID;
230: BEGIN
231:

Line 306: UPDATE CZ_IMP_PRICE_GROUP

302: END IF;
303: END;
304: END IF;
305:
306: UPDATE CZ_IMP_PRICE_GROUP
307: SET price_group_id = DECODE(sDISPOSITION,'R',PRICE_GROUP_ID,'I',nNextValue+nAllocateCounter, nPriceGroupId),
308: DISPOSITION=sDisposition, REC_STATUS=sRecStatus
309: WHERE ROWID = thisRowId;
310: sLastFSK:=sThisFSK;