[Home] [Help]
179: FROM ps_matl_hdr pmh
180: WHERE pmh.matl_rep_id = G_matl_rep_id
181: AND
182: ((pmh.inventory_item_id NOT IN (SELECT pud1.inventory_item_id
183: FROM ps_ubkt_dtl pud1
184: WHERE pud1.matl_rep_id = G_matl_rep_id))
185: OR
186: (pmh.organization_id NOT IN (SELECT organization_id
187: FROM ps_ubkt_dtl pud2
183: FROM ps_ubkt_dtl pud1
184: WHERE pud1.matl_rep_id = G_matl_rep_id))
185: OR
186: (pmh.organization_id NOT IN (SELECT organization_id
187: FROM ps_ubkt_dtl pud2
188: WHERE pud2.inventory_item_id = pmh.inventory_item_id
189: AND pud2.matl_rep_id = G_matl_rep_id)));
190: END IF;
191:
459: CURSOR Cur_check_dtl IS
460: SELECT 1
461: FROM FND_DUAL
462: WHERE EXISTS (SELECT matl_rep_id
463: FROM ps_ubkt_dtl
464: WHERE matl_rep_id = G_matl_rep_id) ;
465:
466: X_ret NUMBER;
467: X_i NUMBER := 0;
1193: X_pastdue := NULL;
1194: END IF;
1195: --Insert the record into the detail table.
1196:
1197: INSERT INTO ps_ubkt_dtl(matl_rep_id,
1198: -- item_id,
1199: inventory_item_id,
1200: -- planning_class,
1201: -- whse_code,
1242: X_pastdue := NULL;
1243: END IF;
1244:
1245:
1246: INSERT INTO ps_ubkt_dtl(matl_rep_id,
1247: -- item_id,
1248: inventory_item_id,
1249: -- planning_class,
1250: -- whse_code,
1297:
1298: EXCEPTION
1299: WHEN OTHERS THEN
1300: -- X_WHSE_LIST:=SQLERRM;
1301: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to ps_ubkt_dtl'||sqlerrm);
1302:
1303: /* b3668927 nsinghi : Closing cursors in exception block. */
1304: IF dbms_sql.is_open(X_doc) THEN
1305: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');
1851: ' pud.critical_ind critical_ind, ' ||
1852: ' pud.cust_vend cust_vend, ' ||
1853: ' pud.inventory_item_id inventory_item_id, ' ||
1854: ' gmpmpact.organization_code (pud.organization_id) organization_code ' ||
1855: ' FROM ps_ubkt_dtl pud ' ||
1856: ' WHERE pud.inventory_item_id = pmh.inventory_item_id ' ||
1857: ' AND pud.organization_id = pmh.organization_id ' ||
1858: ' AND pud.matl_rep_id = pmh.matl_rep_id ' ||
1859: --Modified order by clause as per bug # 11072275