APPS.ECE_SPSO_TRANS1 dependencies on CHV_SCHEDULE_HEADERS

Line 1775: chv_schedule_headers csh,

1771: FROM
1772: chv_cum_periods ccp,
1773: ece_tp_details etd,
1774: po_vendor_sites pvs,
1775: chv_schedule_headers csh,
1776: chv_org_options coo
1777: WHERE
1778: csh.schedule_status = 'CONFIRMED'
1779: AND etd.edi_flag = 'Y' -- EDI

Line 1871: chv_schedule_headers csh,

1867: ccp.cum_period_start_date SHIP_TO_ORG_CUM_PERIOD_START,
1868: csi.last_receipt_transaction_id LAST_RECEIPT_TRANSACTION_ID,
1869: csi.purchasing_unit_of_measure PURCHASING_UNIT_OF_MEASURE
1870: FROM
1871: chv_schedule_headers csh,
1872: chv_schedule_items csi,
1873: chv_org_options coo,
1874: chv_cum_periods ccp,
1875: mtl_item_flexfields mif,

Line 2032: ece_spso_trans1.update_chv_schedule_headers ( rec_hdr.transaction_type,

2028: ** insert prior authorization detail **
2029: ***************************************/
2030:
2031: xProgress := 'SPSOB-30-1050';
2032: ece_spso_trans1.update_chv_schedule_headers ( rec_hdr.transaction_type,
2033: rec_hdr.schedule_id,
2034: rec_hdr.batch_id, --Bug 2064311
2035: rec_hdr.edi_count );
2036: Select count(*)

Line 2418: ** procedure UPDATE_CHV_SCHEDULE_HEADERS **

2414: END Populate_Supplier_Sched_API3; -- end of procedure
2415:
2416:
2417: /*************************************************************************
2418: ** procedure UPDATE_CHV_SCHEDULE_HEADERS **
2419: ** This procedure will update the records in CHV_SCHEDULE_HEADERS table**
2420: ** which have been extracted for EDI transmission. The communication **
2421: ** code will be set according to their inital value. If the record is **
2422: ** flaged for BOTH print and edi, after performing EDI transaction it **

Line 2419: ** This procedure will update the records in CHV_SCHEDULE_HEADERS table**

2415:
2416:
2417: /*************************************************************************
2418: ** procedure UPDATE_CHV_SCHEDULE_HEADERS **
2419: ** This procedure will update the records in CHV_SCHEDULE_HEADERS table**
2420: ** which have been extracted for EDI transmission. The communication **
2421: ** code will be set according to their inital value. If the record is **
2422: ** flaged for BOTH print and edi, after performing EDI transaction it **
2423: ** will be reset to print. If the initial vaues is EDI then after **

Line 2427: PROCEDURE Update_CHV_Schedule_Headers ( p_transaction_type IN VARCHAR2,

2423: ** will be reset to print. If the initial vaues is EDI then after **
2424: ** completion of transaction the code will be set to NONE. **
2425: *************************************************************************/
2426:
2427: PROCEDURE Update_CHV_Schedule_Headers ( p_transaction_type IN VARCHAR2,
2428: p_schedule_id IN INTEGER := 0,
2429: p_batch_id IN NUMBER,
2430: p_edi_count IN NUMBER := 0 )
2431: IS

Line 2438: ec_debug.push ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );

2434: cOutput_path varchar2(120);
2435:
2436: BEGIN
2437:
2438: ec_debug.push ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );
2439: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2440: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
2441: ec_debug.pl ( 3, 'p_edi_count: ',p_edi_count );
2442:

Line 2457: UPDATE chv_schedule_headers

2453: ec_debug.pl ( 3, 'cOutput_path: ',cOutput_path );
2454:
2455: xProgress := 'SPSOB-40-1000';
2456:
2457: UPDATE chv_schedule_headers
2458: SET communication_code = DECODE ( communication_code,
2459: 'BOTH', 'PRINT',
2460: 'EDI', 'NONE',
2461: 'NONE', 'NONE',

Line 2476: ec_debug.pop ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );

2472: AND p_transaction_type = DECODE ( schedule_type,
2473: 'SHIP_SCHEDULE', 'SSSO',
2474: 'SPSO' )
2475: AND batch_id = decode(p_batch_id,0,batch_id,p_batch_id); -- Bug 2064311
2476: ec_debug.pop ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );
2477:
2478: EXCEPTION
2479: WHEN OTHERS THEN
2480: ec_debug.pl ( 0,

Line 2494: END Update_CHV_Schedule_Headers;

2490: SQLERRM );
2491:
2492: app_exception.raise_exception;
2493:
2494: END Update_CHV_Schedule_Headers;
2495:
2496:
2497: /*************************************************************************
2498: ** procedure PUT_DATA_TO_OUTPUT_TABLE **