APPS.ECE_RULES_PKG dependencies on ECE_TP_DETAILS

Line 366: l_translator_code ece_tp_details.translator_code%TYPE;

362: xProgress VARCHAR2(80);
363: n_location_code_pos NUMBER;
364: n_translator_code_pos NUMBER;
365: l_location_code VARCHAR2(35);
366: l_translator_code ece_tp_details.translator_code%TYPE;
367: l_map_code ece_mappings.map_code%TYPE;
368: loop_count NUMBER:=0;
369: n_org_id NUMBER;
370: l_org_id NUMBER ;

Line 378: from ece_tp_details td,

374:
375: CURSOR c_cust_addr IS
376: select td.tp_detail_id,
377: nvl(td.edi_flag,'N')
378: from ece_tp_details td,
379: hz_cust_acct_sites_all ra
380: where td.translator_code = l_translator_code and
381: ra.ece_tp_location_code = l_location_code and
382: ra.tp_header_id = td.tp_header_id and

Line 392: from ece_tp_details td,

388:
389: CURSOR c_supplier_addr IS
390: select td.tp_detail_id,
391: nvl(td.edi_flag,'N')
392: from ece_tp_details td,
393: po_vendor_sites_all pvs
394: where td.translator_code = l_translator_code and
395: pvs.ece_tp_location_code = l_location_code and
396: pvs.tp_header_id = td.tp_header_id and

Line 405: from ece_tp_details td,

401:
402: CURSOR c_bank_addr IS
403: select td.tp_detail_id,
404: nvl(td.edi_flag,'N')
405: from ece_tp_details td,
406: ce_bank_branches_v cbb,
407: hz_contact_points hcp
408: where td.translator_code = l_translator_code and
409: hcp.edi_ece_tp_location_code = l_location_code and

Line 421: from ece_tp_details td,

417:
418: CURSOR c_hr_addr IS
419: select td.tp_detail_id,
420: nvl(td.edi_flag,'N')
421: from ece_tp_details td,
422: hr_locations hrl
423: where td.translator_code = l_translator_code and
424: hrl.ece_tp_location_code = l_location_code and
425: hrl.tp_header_id = td.tp_header_id and

Line 618: l_file_test_flag ece_tp_details.test_flag%TYPE;

614: x_valid_rule OUT NOCOPY VARCHAR2) IS
615:
616: xProgress VARCHAR2(80);
617: n_test_flag_pos NUMBER;
618: l_file_test_flag ece_tp_details.test_flag%TYPE;
619: l_setup_test_flag ece_tp_details.test_flag%TYPE;
620: no_row_selected EXCEPTION;
621:
622: CURSOR c_test_flag IS

Line 619: l_setup_test_flag ece_tp_details.test_flag%TYPE;

615:
616: xProgress VARCHAR2(80);
617: n_test_flag_pos NUMBER;
618: l_file_test_flag ece_tp_details.test_flag%TYPE;
619: l_setup_test_flag ece_tp_details.test_flag%TYPE;
620: no_row_selected EXCEPTION;
621:
622: CURSOR c_test_flag IS
623: select test_flag

Line 624: from ece_tp_details

620: no_row_selected EXCEPTION;
621:
622: CURSOR c_test_flag IS
623: select test_flag
624: from ece_tp_details
625: where tp_detail_id = p_tp_detail_id and
626: rownum = 1;
627:
628: BEGIN

Line 683: 'TABLE_NAME', 'ECE_TP_DETAILS');

679: end if;
680: ec_debug.pl (0, 'EC', 'ECE_NO_ROW_SELECTED',
681: 'PROGRESS_LEVEL', xProgress,
682: 'INFO', 'TEST_FLAG',
683: 'TABLE_NAME', 'ECE_TP_DETAILS');
684: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_TEST_PROD');
685: raise fnd_api.g_exc_error;
686:
687: WHEN OTHERS THEN