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.CSP_TRANSACTIONS_PUB dependencies on CSP_REQ_LINE_DETAILS

Line 2352: csp_req_line_details d

2348: select h.task_id, l.requirement_line_id
2349: from
2350: csp_requirement_headers h,
2351: csp_requirement_lines l,
2352: csp_req_line_details d
2353: where d.req_line_detail_id = p_req_line_detail_id
2354: and d.requirement_line_id = l.requirement_line_id
2355: and l.requirement_header_id = h.requirement_header_id
2356: and h.task_id is not null;

Line 2438: csp_req_line_details d

2434: SELECT h.destination_organization_id,
2435: h.destination_subinventory
2436: FROM csp_requirement_headers h,
2437: csp_requirement_lines l,
2438: csp_req_line_details d
2439: WHERE d.req_line_detail_id = p_req_line_detail_id
2440: AND d.requirement_line_id = l.requirement_line_id
2441: AND l.requirement_header_id = h.requirement_header_id;
2442:

Line 2722: 'Before calling csp_req_line_details_pkg.delete_row...');

2718: if l_remaining_quantity = 0 or p_close_short = 'Y' then
2719: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2720: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2721: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2722: 'Before calling csp_req_line_details_pkg.delete_row...');
2723: end if;
2724: csp_req_line_details_pkg.delete_row(p_req_line_detail_id);
2725: commit;
2726: end if;

Line 2724: csp_req_line_details_pkg.delete_row(p_req_line_detail_id);

2720: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2721: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2722: 'Before calling csp_req_line_details_pkg.delete_row...');
2723: end if;
2724: csp_req_line_details_pkg.delete_row(p_req_line_detail_id);
2725: commit;
2726: end if;
2727:
2728: else

Line 2769: 'Before calling csp_req_line_details_pkg.Update_Row...');

2765:
2766: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2768: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2769: 'Before calling csp_req_line_details_pkg.Update_Row...');
2770: end if;
2771:
2772: csp_req_line_details_pkg.Update_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
2773: p_REQUIREMENT_LINE_ID => l_requirement_line_id,

Line 2772: csp_req_line_details_pkg.Update_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,

2768: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2769: 'Before calling csp_req_line_details_pkg.Update_Row...');
2770: end if;
2771:
2772: csp_req_line_details_pkg.Update_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
2773: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
2774: p_CREATED_BY => FND_GLOBAL.user_id,
2775: p_CREATION_DATE => sysdate,
2776: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,

Line 2786: 'Before calling csp_req_line_details_pkg.Insert_Row...');

2782:
2783: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2784: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2785: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2786: 'Before calling csp_req_line_details_pkg.Insert_Row...');
2787: end if;
2788:
2789: csp_req_line_details_pkg.Insert_Row(
2790: px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,

Line 2789: csp_req_line_details_pkg.Insert_Row(

2785: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2786: 'Before calling csp_req_line_details_pkg.Insert_Row...');
2787: end if;
2788:
2789: csp_req_line_details_pkg.Insert_Row(
2790: px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
2791: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
2792: p_CREATED_BY => FND_GLOBAL.user_id,
2793: p_CREATION_DATE => sysdate,

Line 2995: csp_req_line_details cd

2991:
2992: SELECT nvl(SUM(mr.reservation_quantity), 0)
2993: INTO l_already_res_qty
2994: FROM mtl_reservations mr,
2995: csp_req_line_details cd
2996: WHERE mr.reservation_id = cd.source_id
2997: AND cd.source_type = 'RES'
2998: AND cd.requirement_line_id = l_requirement_line_id
2999: AND cd.source_id <> l_new_reservation_id;

Line 3012: csp_req_line_details csp

3008: SELECT req.quantity
3009: INTO l_total_req_qty
3010: FROM po_requisition_lines_all req,
3011: oe_order_lines_all ord,
3012: csp_req_line_details csp
3013: WHERE req.requisition_line_id = ord.source_document_line_id
3014: AND ord.line_id = csp.source_id
3015: AND csp.source_type = 'IO'
3016: AND csp.req_line_detail_id = l_req_line_detail_id;

Line 3026: FROM csp_req_line_details

3022: end if;
3023:
3024: SELECT COUNT(*)
3025: INTO l_res_exists
3026: FROM csp_req_line_details
3027: WHERE requirement_line_id = l_requirement_line_id
3028: AND source_type = 'RES'
3029: AND source_id = l_new_reservation_id;
3030:

Line 3043: 'Before calling csp_req_line_details_pkg.Insert_Row...');

3039: if l_res_exists = 0 then
3040: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3041: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3042: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3043: 'Before calling csp_req_line_details_pkg.Insert_Row...');
3044: end if;
3045:
3046: l_req_line_detail_id := null;
3047: csp_req_line_details_pkg.Insert_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,

Line 3047: csp_req_line_details_pkg.Insert_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,

3043: 'Before calling csp_req_line_details_pkg.Insert_Row...');
3044: end if;
3045:
3046: l_req_line_detail_id := null;
3047: csp_req_line_details_pkg.Insert_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
3048: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
3049: p_CREATED_BY => FND_GLOBAL.user_id,
3050: p_CREATION_DATE => sysdate,
3051: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,

Line 3062: --csp_req_line_details_pkg.delete_row(l_req_line_detail_id);

3058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3059: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3060: 'deleting.... l_req_line_detail_id = ' || l_req_line_detail_id);
3061: end if;
3062: --csp_req_line_details_pkg.delete_row(l_req_line_detail_id);
3063: end if;
3064: else
3065:
3066: if l_res_exists = 0 then

Line 3070: 'Before calling csp_req_line_details_pkg.Insert_Row...');

3066: if l_res_exists = 0 then
3067: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3068: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3069: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3070: 'Before calling csp_req_line_details_pkg.Insert_Row...');
3071: end if;
3072:
3073: l_req_line_detail_id := null;
3074: csp_req_line_details_pkg.Insert_Row(

Line 3074: csp_req_line_details_pkg.Insert_Row(

3070: 'Before calling csp_req_line_details_pkg.Insert_Row...');
3071: end if;
3072:
3073: l_req_line_detail_id := null;
3074: csp_req_line_details_pkg.Insert_Row(
3075: px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
3076: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
3077: p_CREATED_BY => FND_GLOBAL.user_id,
3078: p_CREATION_DATE => sysdate,

Line 3223: csp_req_line_details crld,

3219: crld.req_line_detail_id,
3220: crl.requirement_line_id
3221: FROM csp_requirement_headers crh,
3222: csp_requirement_lines crl,
3223: csp_req_line_details crld,
3224: rcv_shipment_lines rsl,
3225: oe_order_lines_all oola,
3226: mtl_material_transactions mmt
3227: WHERE rsl.SHIPMENT_HEADER_ID = l_shipment_header_id

Line 3318: FROM csp_req_line_details

3314:
3315:
3316: SELECT COUNT(*)
3317: INTO l_res_exists
3318: FROM csp_req_line_details
3319: WHERE requirement_line_id = grd.requirement_line_id
3320: AND source_type = 'RES'
3321: AND source_id = l_reservation_id;
3322:

Line 3334: csp_req_line_details_pkg.insert_row(px_req_line_detail_id => l_req_line_detali_id

3330:
3331: IF l_reservation_id IS NOT NULL AND l_reservation_id > 0 THEN
3332:
3333: if l_res_exists = 0 then
3334: csp_req_line_details_pkg.insert_row(px_req_line_detail_id => l_req_line_detali_id
3335: ,p_requirement_line_id => grd.requirement_line_id
3336: ,p_created_by => FND_GLOBAL.user_id
3337: ,p_creation_date => sysdate
3338: ,p_last_updated_by => FND_GLOBAL.user_id

Line 3358: csp_req_line_details cd

3354: SELECT nvl(SUM(mr.reservation_quantity), 0)
3355: INTO l_already_res_qty
3356: FROM mtl_reservations mr,
3357: csp_requirement_lines cl,
3358: csp_req_line_details cd
3359: WHERE mr.reservation_id = cd.source_id
3360: AND cd.source_type = 'RES'
3361: AND cl.requirement_line_id = grd.requirement_line_id
3362: AND cd.requirement_line_id = cl.requirement_line_id

Line 3375: csp_req_line_details_pkg.delete_row(grd.req_line_detail_id);

3371: 'grd.ord_qty = ' || grd.ord_qty);
3372: end if;
3373:
3374: IF (l_total_reserved_qty + l_already_res_qty) >= grd.ord_qty THEN
3375: csp_req_line_details_pkg.delete_row(grd.req_line_detail_id);
3376: END IF;
3377:
3378: END IF;
3379: