APPS.CS_UPDATE_CP_SHIPPED_FLAG dependencies on CS_CUSTOMER_PRODUCTS_ALL

Line 18: from cs_customer_products_all;

14: upgraded_status_flag_mig StaTabType;
15:
16: CURSOR m1 is
17: select min(customer_product_id)
18: from cs_customer_products_all;
19:
20: CURSOR m2 is
21: select max(customer_product_id)
22: from cs_customer_products_all;

Line 22: from cs_customer_products_all;

18: from cs_customer_products_all;
19:
20: CURSOR m2 is
21: select max(customer_product_id)
22: from cs_customer_products_all;
23:
24: CURSOR c1(p_start number, p_end number) is
25: select ccp.customer_product_id,
26: ccp.shipped_flag,

Line 29: from cs_customer_products_all ccp

25: select ccp.customer_product_id,
26: ccp.shipped_flag,
27: nvl(ccp.upgraded_status_flag,'N'),
28: ccp.rowid
29: from cs_customer_products_all ccp
30: where customer_product_id >= p_start and customer_product_id <= p_end
31: and ccp.shipped_flag <> 'Y'
32: and ccp.upgraded_status_flag = 'Y';
33:

Line 74: UPDATE cs_customer_products_all

70: end if;
71: End loop;
72:
73: FORALL j in 1..customer_product_mig.count
74: UPDATE cs_customer_products_all
75: SET shipped_flag = shipped_flag_mig(j)
76: WHERE rowid = Rowid_mig(j);
77:
78: commit;