DBA Data[Home] [Help]

APPS.ECE_SPSO_TRANS1 dependencies on ECE_SPSO_ITEM_DET

Line 31: p_item_d_interface VARCHAR2(120) := 'ECE_SPSO_ITEM_DET';

27: p_output_width INTEGER := 4000;
28: p_run_id INTEGER;
29: p_header_interface VARCHAR2(120) := 'ECE_SPSO_HEADERS';
30: p_item_interface VARCHAR2(120) := 'ECE_SPSO_ITEMS';
31: p_item_d_interface VARCHAR2(120) := 'ECE_SPSO_ITEM_DET';
32: p_transaction_date DATE := SYSDATE;
33: xProgress VARCHAR2(30);
34: cEnabled VARCHAR2(1) := 'Y';
35: ece_transaction_disabled EXCEPTION;

Line 302: p_item_d_interface VARCHAR2(120) := 'ECE_SPSO_ITEM_DET';

298: p_output_width INTEGER := 4000;
299: p_run_id NUMBER ;
300: p_header_interface VARCHAR2(120) := 'ECE_SPSO_HEADERS';
301: p_item_interface VARCHAR2(120) := 'ECE_SPSO_ITEMS';
302: p_item_d_interface VARCHAR2(120) := 'ECE_SPSO_ITEM_DET';
303: p_transaction_date DATE := SYSDATE;
304: cEnabled VARCHAR2(1) := 'Y';
305: ece_transaction_disabled EXCEPTION;
306:

Line 1929: FROM ece_spso_item_det

1925: BEGIN
1926: xProgress := 'SPSOB-30-1020';
1927: SELECT MAX(schedule_item_detail_sequence)
1928: INTO x_item_detail_sequence
1929: FROM ece_spso_item_det
1930: WHERE schedule_id = rec_item.schedule_id
1931: AND schedule_item_id = rec_item.schedule_item_id;
1932: EXCEPTION
1933: WHEN NO_DATA_FOUND THEN

Line 1942: 'ECE_SPSO_ITEM_DET' );

1938: xProgress,
1939: 'INFO',
1940: 'MAX(SCHEDULE_ITEM_DETAIL_SEQUENCE)',
1941: 'TABLE_NAME',
1942: 'ECE_SPSO_ITEM_DET' );
1943: END;
1944:
1945: ec_debug.pl ( 3, 'x_item_detail_sequence: ',x_item_detail_sequence );
1946:

Line 2070: INSERT INTO ece_spso_item_det

2066: xProgress := 'SPSOB-30-1080';
2067: x_item_detail_sequence := NVL(x_item_detail_sequence,0) + 1;
2068:
2069: xProgress := 'SPSOB-30-1090';
2070: INSERT INTO ece_spso_item_det
2071: (
2072: run_id,
2073: schedule_item_detail_sequence,
2074: schedule_id,

Line 2096: ece_spso_item_det_s.nextval

2092: rec_hdr.forecast_horizon_start_date,
2093: 0,
2094: 0,
2095: NVL(rec_item.starting_auth_quantity,0),
2096: ece_spso_item_det_s.nextval
2097: );
2098: -- Bug 1742567
2099: select
2100: ece_spso_item_det_s.currval

Line 2100: ece_spso_item_det_s.currval

2096: ece_spso_item_det_s.nextval
2097: );
2098: -- Bug 1742567
2099: select
2100: ece_spso_item_det_s.currval
2101: into
2102: l_transaction_number
2103: from
2104: dual;

Line 2145: INSERT INTO ece_spso_item_det

2141: x_item_detail_sequence := NVL(x_item_detail_sequence,0) + 1;
2142:
2143: xProgress := 'SPSOB-30-1120';
2144:
2145: INSERT INTO ece_spso_item_det
2146: (
2147: run_id,
2148: schedule_item_detail_sequence,
2149: schedule_id,

Line 2173: ece_spso_item_det_s.nextval

2169: rec_detail.cutoff_date,
2170: 0,
2171: 0,
2172: NVL(rec_detail.schedule_quantity,0),
2173: ece_spso_item_det_s.nextval
2174: );
2175: -- Bug 1742567
2176: select
2177: ece_spso_item_det_s.currval

Line 2177: ece_spso_item_det_s.currval

2173: ece_spso_item_det_s.nextval
2174: );
2175: -- Bug 1742567
2176: select
2177: ece_spso_item_det_s.currval
2178: into
2179: l_transaction_number
2180: from
2181: dual;

Line 2235: INSERT INTO ece_spso_item_det

2231: WHERE transaction_record_id = x_transaction_record_id;
2232:
2233: xProgress := 'SPSOB-30-1160';
2234:
2235: INSERT INTO ece_spso_item_det
2236: (
2237: run_id,
2238: schedule_item_detail_sequence,
2239: schedule_id,

Line 2265: ece_spso_item_det_s.nextval

2261: 0,
2262: NVL(x_last_quantity,0),
2263: 'SHIPMENT',
2264: x_shipment_num,
2265: ece_spso_item_det_s.nextval
2266: );
2267: -- Bug 1742567
2268: select
2269: ece_spso_item_det_s.currval

Line 2269: ece_spso_item_det_s.currval

2265: ece_spso_item_det_s.nextval
2266: );
2267: -- Bug 1742567
2268: select
2269: ece_spso_item_det_s.currval
2270: into
2271: l_transaction_number
2272: from
2273: dual;

Line 2297: INSERT INTO ece_spso_item_det

2293: ec_debug.pl ( 3, 'x_item_detail_sequence: ',x_item_detail_sequence );
2294:
2295: xProgress := 'SPSOB-30-1180';
2296:
2297: INSERT INTO ece_spso_item_det
2298: (
2299: run_id,
2300: schedule_item_detail_sequence,
2301: schedule_id,

Line 2325: ece_spso_item_det_s.nextval

2321: rec_hdr.forecast_horizon_start_date,
2322: 0,
2323: 0,
2324: NVL(rec_item.starting_cum_quantity,0),
2325: ece_spso_item_det_s.nextval
2326: );
2327: -- Bug 1742567
2328: select
2329: ece_spso_item_det_s.currval

Line 2329: ece_spso_item_det_s.currval

2325: ece_spso_item_det_s.nextval
2326: );
2327: -- Bug 1742567
2328: select
2329: ece_spso_item_det_s.currval
2330: into
2331: l_transaction_number
2332: from
2333: dual;

Line 2519: p_item_d_interface IN VARCHAR2 := 'ECE_SPSO_ITEM_DET',

2515: p_output_width IN INTEGER,
2516: p_run_id IN INTEGER,
2517: p_header_interface IN VARCHAR2 := 'ECE_SPSO_HEADERS',
2518: p_item_interface IN VARCHAR2 := 'ECE_SPSO_ITEMS',
2519: p_item_d_interface IN VARCHAR2 := 'ECE_SPSO_ITEM_DET',
2520: p_ship_d_interface IN VARCHAR2 := 'ECE_SPSO_SHIP_DET')
2521: IS
2522: xProgress VARCHAR2(30);
2523: cOutput_path VARCHAR2(120);