DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on CSP_SCH_INT_PVT

Line 2336: l_RESERVATION_REC CSP_SCH_INT_PVT.RESERVATION_REC_TYP;

2332: l_task_id number;
2333: l_requirement_line_id number;
2334: l_new_reservation_id number;
2335: l_req_line_detail_id number;
2336: l_RESERVATION_REC CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
2337: l_if_intransit boolean;
2338:
2339: l_inv_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2340: l_serial_number inv_reservation_global.serial_number_tbl_type;

Line 2558: CSP_SCH_INT_PVT.CANCEL_RESERVATION(

2554: 'p_close_short=' || p_close_short);
2555: end if;
2556:
2557: if p_close_short = 'Y' then
2558: CSP_SCH_INT_PVT.CANCEL_RESERVATION(
2559: p_reserv_id => p_trans_header_id,
2560: x_return_status => x_return_status,
2561: x_msg_data => x_msg_count,
2562: x_msg_count => x_msg_data

Line 2568: 'After calling CSP_SCH_INT_PVT.CANCEL_RESERVATION...');

2564:
2565: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2567: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2568: 'After calling CSP_SCH_INT_PVT.CANCEL_RESERVATION...');
2569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2570: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2571: 'x_return_status=' || x_return_status ||
2572: ', x_msg_count=' || x_msg_count ||

Line 2742: 'Before calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');

2738:
2739: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2740: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2741: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2742: 'Before calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2743: end if;
2744:
2745: l_new_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(
2746: p_reservation_parts => l_RESERVATION_REC,

Line 2745: l_new_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(

2741: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2742: 'Before calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2743: end if;
2744:
2745: l_new_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(
2746: p_reservation_parts => l_RESERVATION_REC,
2747: x_return_status => x_return_status,
2748: x_msg_data => x_msg_data);
2749:

Line 2753: 'After calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');

2749:
2750: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2751: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2752: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2753: 'After calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2754: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2755: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2756: 'x_return_status=' || x_return_status ||
2757: ', x_msg_data=' || x_msg_data ||

Line 2960: 'Before calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');

2956:
2957: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2958: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2959: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2960: 'Before calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2961: end if;
2962:
2963: l_new_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(
2964: p_reservation_parts => l_RESERVATION_REC,

Line 2963: l_new_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(

2959: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2960: 'Before calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2961: end if;
2962:
2963: l_new_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(
2964: p_reservation_parts => l_RESERVATION_REC,
2965: x_return_status => x_return_status,
2966: x_msg_data => x_msg_data);
2967:

Line 2971: 'After calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');

2967:
2968: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2969: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2970: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2971: 'After calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2972: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2973: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2974: 'x_return_status=' || x_return_status ||
2975: ', x_msg_data=' || x_msg_data ||

Line 3201: l_reservation_parts CSP_SCH_INT_PVT.RESERVATION_REC_TYP;

3197: function res_for_rcv_trans(p_subscription_guid IN RAW,
3198: p_event IN OUT NOCOPY wf_event_t) return varchar2 is
3199:
3200: l_shipment_header_id number;
3201: l_reservation_parts CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
3202: l_reservation_id NUMBER;
3203: l_req_line_detali_id NUMBER;
3204: x_return_Status varchar2(1);
3205: x_msg_data varchar2(4000);

Line 3299: l_reservation_id := csp_sch_int_pvt.CREATE_RESERVATION(l_reservation_parts

3295: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3296: 'l_reservation_parts.revision = ' || l_reservation_parts.revision);
3297: end if;
3298:
3299: l_reservation_id := csp_sch_int_pvt.CREATE_RESERVATION(l_reservation_parts
3300: ,x_return_status
3301: ,x_msg_data );
3302:
3303: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then