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.ECE_SPSO_TRANS1 dependencies on ECE_FLATFILE_PVT

Line 606: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;

602: xProgress VARCHAR2(30);
603: v_LevelProcessed VARCHAR2(40);
604: cOutput_path VARCHAR2(120);
605:
606: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
607: l_item_tbl ece_flatfile_pvt.Interface_tbl_type;
608: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
609:
610: Header_sel_c INTEGER;

Line 607: l_item_tbl ece_flatfile_pvt.Interface_tbl_type;

603: v_LevelProcessed VARCHAR2(40);
604: cOutput_path VARCHAR2(120);
605:
606: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
607: l_item_tbl ece_flatfile_pvt.Interface_tbl_type;
608: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
609:
610: Header_sel_c INTEGER;
611: Item_sel_c INTEGER;

Line 608: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;

604: cOutput_path VARCHAR2(120);
605:
606: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
607: l_item_tbl ece_flatfile_pvt.Interface_tbl_type;
608: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
609:
610: Header_sel_c INTEGER;
611: Item_sel_c INTEGER;
612: Item_D_sel_c INTEGER;

Line 754: ece_flatfile_pvt.INIT_TABLE ( cTransaction_Type,

750: ec_debug.pl ( 3, 'cOutput_path: ',cOutput_path );
751:
752:
753: xProgress := 'SPSOB-10-1000';
754: ece_flatfile_pvt.INIT_TABLE ( cTransaction_Type,
755: cHeader_Interface,
756: NULL,
757: FALSE,
758: l_header_tbl,

Line 765: ece_flatfile_pvt.INIT_TABLE ( cTransaction_Type,

761: xProgress := 'SPSOB-10-1020';
762: l_key_tbl := l_header_tbl;
763:
764: xProgress := 'SPSOB-10-1030';
765: ece_flatfile_pvt.INIT_TABLE ( cTransaction_Type,
766: cItem_Interface,
767: NULL,
768: TRUE,
769: l_item_tbl,

Line 816: -- Procedure ece_flatfile_pvt.Find_pos will be used to locate the specific

812: -- **************************************************************************
813: -- **************************************************************************
814: -- :po_header_id is a place holder for foreign key value.
815: -- A PL/SQL table (list of values) will be used to store data.
816: -- Procedure ece_flatfile_pvt.Find_pos will be used to locate the specific
817: -- data value in the PL/SQL table.
818: -- dbms_sql (Native Oracle db functions that come with every Oracle Apps)
819: -- dbms_sql.bind_variable will be used to assign data value to :transaction_id.
820: --

Line 2525: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;

2521: IS
2522: xProgress VARCHAR2(30);
2523: cOutput_path VARCHAR2(120);
2524:
2525: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2526: l_item_tbl ece_flatfile_pvt.Interface_tbl_type;
2527: l_item_d_tbl ece_flatfile_pvt.Interface_tbl_type;
2528: l_ship_d_tbl ece_flatfile_pvt.Interface_tbl_type;
2529:

Line 2526: l_item_tbl ece_flatfile_pvt.Interface_tbl_type;

2522: xProgress VARCHAR2(30);
2523: cOutput_path VARCHAR2(120);
2524:
2525: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2526: l_item_tbl ece_flatfile_pvt.Interface_tbl_type;
2527: l_item_d_tbl ece_flatfile_pvt.Interface_tbl_type;
2528: l_ship_d_tbl ece_flatfile_pvt.Interface_tbl_type;
2529:
2530: c_header_common_key_name VARCHAR2(40);

Line 2527: l_item_d_tbl ece_flatfile_pvt.Interface_tbl_type;

2523: cOutput_path VARCHAR2(120);
2524:
2525: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2526: l_item_tbl ece_flatfile_pvt.Interface_tbl_type;
2527: l_item_d_tbl ece_flatfile_pvt.Interface_tbl_type;
2528: l_ship_d_tbl ece_flatfile_pvt.Interface_tbl_type;
2529:
2530: c_header_common_key_name VARCHAR2(40);
2531: c_item_common_key_name VARCHAR2(40);

Line 2528: l_ship_d_tbl ece_flatfile_pvt.Interface_tbl_type;

2524:
2525: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2526: l_item_tbl ece_flatfile_pvt.Interface_tbl_type;
2527: l_item_d_tbl ece_flatfile_pvt.Interface_tbl_type;
2528: l_ship_d_tbl ece_flatfile_pvt.Interface_tbl_type;
2529:
2530: c_header_common_key_name VARCHAR2(40);
2531: c_item_common_key_name VARCHAR2(40);
2532: c_item_d_common_key_name VARCHAR2(40);

Line 2644: -- The ece_flatfile_pvt.select_clause uses the db data dictionary for the build.

2640:
2641: /* --------------------------------------------------------------------------
2642: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic
2643: -- SQL call
2644: -- The ece_flatfile_pvt.select_clause uses the db data dictionary for the build.
2645: -- (The db data dictionary store contains all types of info about Interface
2646: -- tables and Extension tables.)
2647:
2648: -- The DELETE clauses will be used to clean up both the interface and extension

Line 2654: ece_flatfile_pvt.select_clause ( p_transaction_type,

2650: -- being written to the output table, thus, can be deleted.
2651: --------------------------------------------------------------------------*/
2652:
2653: xProgress := 'SPSOB-50-1000';
2654: ece_flatfile_pvt.select_clause ( p_transaction_type,
2655: p_communication_method,
2656: p_header_interface,
2657: x_header_x_interface,
2658: l_header_tbl,

Line 2665: ece_flatfile_pvt.select_clause ( p_transaction_type,

2661: x_header_from,
2662: x_header_where );
2663:
2664: xProgress := 'SPSOB-50-1010';
2665: ece_flatfile_pvt.select_clause ( p_transaction_type,
2666: p_communication_method,
2667: p_item_interface,
2668: x_item_x_interface,
2669: l_item_tbl,

Line 2676: ece_flatfile_pvt.select_clause ( p_transaction_type,

2672: x_item_from ,
2673: x_item_where );
2674:
2675: xProgress := 'SPSOB-50-1020';
2676: ece_flatfile_pvt.select_clause ( p_transaction_type,
2677: p_communication_method,
2678: p_item_d_interface,
2679: x_item_d_x_interface,
2680: l_item_d_tbl,

Line 2688: ece_flatfile_pvt.select_clause ( p_transaction_type,

2684: x_item_d_where );
2685:
2686: xProgress := 'SPSOB-50-1030';
2687: if (p_transaction_type = 'SSSO') then
2688: ece_flatfile_pvt.select_clause ( p_transaction_type,
2689: p_communication_method,
2690: p_ship_d_interface,
2691: x_ship_d_x_interface,
2692: l_ship_d_tbl,

Line 2719: Procedure ece_flatfile_pvt.Find_pos will be used to locate the specific

2715:
2716: /* --------------------------------------------------------------------------
2717: :schedule_id is a place holder for foreign key value.
2718: A PL/SQL table (list of values) will be used to store data.
2719: Procedure ece_flatfile_pvt.Find_pos will be used to locate the specific
2720: data value in the PL/SQL table.
2721: dbms_sql (Native Oracle db functions that come with every Oracle Apps)
2722: dbms_sql.bind_variable will be used to assign data value to :schedule_id
2723:

Line 3183: ece_flatfile_pvt.G_MaxColWidth );

3179:
3180: dbms_sql.define_column ( v_header_sel_c,
3181: k,
3182: x_header_select,
3183: ece_flatfile_pvt.G_MaxColWidth );
3184: END LOOP;
3185:
3186: --********************************************
3187: --*** Need rowid for delete (Header Level) **

Line 3212: ece_flatfile_pvt.G_MaxColWidth );

3208:
3209: dbms_sql.define_column ( v_item_sel_c,
3210: k,
3211: x_item_select,
3212: ece_flatfile_pvt.G_MaxColWidth );
3213: END LOOP;
3214:
3215:
3216: --******************************************

Line 3242: ece_flatfile_pvt.G_MaxColWidth );

3238:
3239: dbms_sql.define_column (v_item_d_sel_c,
3240: k,
3241: x_item_d_select,
3242: ece_flatfile_pvt.G_MaxColWidth );
3243: END LOOP;
3244:
3245:
3246: --**************************************************

Line 3271: ece_flatfile_pvt.G_MaxColWidth);

3267: For k IN 1..x_ship_d_count loop
3268: dbms_sql.define_column ( v_ship_d_sel_c,
3269: k,
3270: x_ship_d_select,
3271: ece_flatfile_pvt.G_MaxColWidth);
3272: End Loop;
3273:
3274:
3275: xProgress := 'SPSOB-50-1502';

Line 3305: nTrans_code_pos := ece_flatfile_pvt.POS_OF ( l_header_tbl,

3301: -- *** This could improve performance.
3302: -- **************************************************
3303:
3304: xProgress := 'SPSOB-50-1510';
3305: nTrans_code_pos := ece_flatfile_pvt.POS_OF ( l_header_tbl,
3306: ece_flatfile_pvt.G_Translator_Code );
3307: ec_debug.pl ( 3, 'nTrans_code_pos: ',nTrans_code_pos );
3308:
3309: xProgress := 'SPSOB-50-1520';

Line 3306: ece_flatfile_pvt.G_Translator_Code );

3302: -- **************************************************
3303:
3304: xProgress := 'SPSOB-50-1510';
3305: nTrans_code_pos := ece_flatfile_pvt.POS_OF ( l_header_tbl,
3306: ece_flatfile_pvt.G_Translator_Code );
3307: ec_debug.pl ( 3, 'nTrans_code_pos: ',nTrans_code_pos );
3308:
3309: xProgress := 'SPSOB-50-1520';
3310: nHeader_key_pos := ece_flatfile_pvt.POS_OF ( l_header_tbl,

Line 3310: nHeader_key_pos := ece_flatfile_pvt.POS_OF ( l_header_tbl,

3306: ece_flatfile_pvt.G_Translator_Code );
3307: ec_debug.pl ( 3, 'nTrans_code_pos: ',nTrans_code_pos );
3308:
3309: xProgress := 'SPSOB-50-1520';
3310: nHeader_key_pos := ece_flatfile_pvt.POS_OF ( l_header_tbl,
3311: c_header_common_key_name );
3312: ec_debug.pl ( 3, 'nHeader_key_pos: ',nHeader_key_pos );
3313:
3314: xProgress := 'SPSOB-50-1530';

Line 3315: nItem_key_pos := ece_flatfile_pvt.POS_OF ( l_item_tbl,

3311: c_header_common_key_name );
3312: ec_debug.pl ( 3, 'nHeader_key_pos: ',nHeader_key_pos );
3313:
3314: xProgress := 'SPSOB-50-1530';
3315: nItem_key_pos := ece_flatfile_pvt.POS_OF ( l_item_tbl,
3316: c_item_common_key_name );
3317: ec_debug.pl ( 3, 'nItem_key_pos: ',nItem_key_pos);
3318:
3319: xProgress := 'SPSOB-50-1540';

Line 3320: nItem_d_key_pos := ece_flatfile_pvt.POS_OF ( l_item_d_tbl,

3316: c_item_common_key_name );
3317: ec_debug.pl ( 3, 'nItem_key_pos: ',nItem_key_pos);
3318:
3319: xProgress := 'SPSOB-50-1540';
3320: nItem_d_key_pos := ece_flatfile_pvt.POS_OF ( l_item_d_tbl,
3321: c_item_d_common_key_name );
3322: ec_debug.pl ( 3, 'nItem_d_key_pos: ',nItem_d_key_pos );
3323:
3324: xProgress := 'SPSOB-50-1545';

Line 3326: nShip_d_key_pos := ece_flatfile_pvt.POS_OF( l_ship_d_tbl,

3322: ec_debug.pl ( 3, 'nItem_d_key_pos: ',nItem_d_key_pos );
3323:
3324: xProgress := 'SPSOB-50-1545';
3325: if (p_transaction_type = 'SSSO') then
3326: nShip_d_key_pos := ece_flatfile_pvt.POS_OF( l_ship_d_tbl,
3327: c_ship_d_common_key_name );
3328:
3329: ec_debug.pl ( 3, 'nShip_d_key_pos: ',nShip_d_key_pos );
3330: end if;

Line 3410: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,

3406: RPAD(' ',22);
3407: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
3408:
3409: xProgress := 'SPSOB-50-1630';
3410: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,
3411: p_communication_method,
3412: p_header_interface,
3413: l_header_tbl,
3414: p_output_width,

Line 3503: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,

3499: RPAD(' ',22);
3500: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
3501:
3502: xProgress := 'SPSOB-50-1730';
3503: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,
3504: p_communication_method,
3505: p_item_interface,
3506: l_item_tbl,
3507: p_output_width,

Line 3587: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,

3583: 22);
3584: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
3585:
3586: xProgress := 'SPSOB-50-1810';
3587: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,
3588: p_communication_method,
3589: p_item_d_interface,
3590: l_item_d_tbl,
3591: p_output_width,

Line 3633: ece_flatfile_pvt.write_to_ece_output(

3629: || rpad(substr(nvl(l_item_tbl(nItem_key_pos).value,' '), 1, 22), 22)
3630: || rpad(substr(nvl(l_item_d_tbl(nItem_d_key_pos).value,' '), 1, 22), 22);
3631:
3632: xProgress := 'SPSOB-50-1845';
3633: ece_flatfile_pvt.write_to_ece_output(
3634: p_transaction_type, p_communication_method, p_ship_d_interface,
3635: l_ship_d_tbl, p_output_width, p_run_id, c_file_common_key);
3636:
3637: xProgress := 'SPSOB-50-1850';