DBA Data[Home] [Help]

APPS.IGS_FI_PRC_APINT dependencies on IGS_LOOKUP_VALUES

Line 32: g_v_lbl_error igs_lookup_values.meaning%TYPE;

28: g_v_transferred CONSTANT VARCHAR2(30) := 'TRANSFERRED';
29: g_v_ind_a CONSTANT VARCHAR2(5) := 'A';
30: g_v_pay_to CONSTANT VARCHAR2(10) := 'PAY_TO';
31:
32: g_v_lbl_error igs_lookup_values.meaning%TYPE;
33: g_v_lbl_person_group igs_lookup_values.meaning%TYPE;
34: g_v_lbl_create_suppl igs_lookup_values.meaning%TYPE;
35: g_v_lbl_suppl_type igs_lookup_values.meaning%TYPE;
36: g_v_lbl_pay_grp igs_lookup_values.meaning%TYPE;

Line 33: g_v_lbl_person_group igs_lookup_values.meaning%TYPE;

29: g_v_ind_a CONSTANT VARCHAR2(5) := 'A';
30: g_v_pay_to CONSTANT VARCHAR2(10) := 'PAY_TO';
31:
32: g_v_lbl_error igs_lookup_values.meaning%TYPE;
33: g_v_lbl_person_group igs_lookup_values.meaning%TYPE;
34: g_v_lbl_create_suppl igs_lookup_values.meaning%TYPE;
35: g_v_lbl_suppl_type igs_lookup_values.meaning%TYPE;
36: g_v_lbl_pay_grp igs_lookup_values.meaning%TYPE;
37: g_v_lbl_inv_term igs_lookup_values.meaning%TYPE;

Line 34: g_v_lbl_create_suppl igs_lookup_values.meaning%TYPE;

30: g_v_pay_to CONSTANT VARCHAR2(10) := 'PAY_TO';
31:
32: g_v_lbl_error igs_lookup_values.meaning%TYPE;
33: g_v_lbl_person_group igs_lookup_values.meaning%TYPE;
34: g_v_lbl_create_suppl igs_lookup_values.meaning%TYPE;
35: g_v_lbl_suppl_type igs_lookup_values.meaning%TYPE;
36: g_v_lbl_pay_grp igs_lookup_values.meaning%TYPE;
37: g_v_lbl_inv_term igs_lookup_values.meaning%TYPE;
38: g_v_lbl_test_run igs_lookup_values.meaning%TYPE;

Line 35: g_v_lbl_suppl_type igs_lookup_values.meaning%TYPE;

31:
32: g_v_lbl_error igs_lookup_values.meaning%TYPE;
33: g_v_lbl_person_group igs_lookup_values.meaning%TYPE;
34: g_v_lbl_create_suppl igs_lookup_values.meaning%TYPE;
35: g_v_lbl_suppl_type igs_lookup_values.meaning%TYPE;
36: g_v_lbl_pay_grp igs_lookup_values.meaning%TYPE;
37: g_v_lbl_inv_term igs_lookup_values.meaning%TYPE;
38: g_v_lbl_test_run igs_lookup_values.meaning%TYPE;
39: g_v_lbl_party igs_lookup_values.meaning%TYPE;

Line 36: g_v_lbl_pay_grp igs_lookup_values.meaning%TYPE;

32: g_v_lbl_error igs_lookup_values.meaning%TYPE;
33: g_v_lbl_person_group igs_lookup_values.meaning%TYPE;
34: g_v_lbl_create_suppl igs_lookup_values.meaning%TYPE;
35: g_v_lbl_suppl_type igs_lookup_values.meaning%TYPE;
36: g_v_lbl_pay_grp igs_lookup_values.meaning%TYPE;
37: g_v_lbl_inv_term igs_lookup_values.meaning%TYPE;
38: g_v_lbl_test_run igs_lookup_values.meaning%TYPE;
39: g_v_lbl_party igs_lookup_values.meaning%TYPE;
40: g_v_lbl_pay igs_lookup_values.meaning%TYPE;

Line 37: g_v_lbl_inv_term igs_lookup_values.meaning%TYPE;

33: g_v_lbl_person_group igs_lookup_values.meaning%TYPE;
34: g_v_lbl_create_suppl igs_lookup_values.meaning%TYPE;
35: g_v_lbl_suppl_type igs_lookup_values.meaning%TYPE;
36: g_v_lbl_pay_grp igs_lookup_values.meaning%TYPE;
37: g_v_lbl_inv_term igs_lookup_values.meaning%TYPE;
38: g_v_lbl_test_run igs_lookup_values.meaning%TYPE;
39: g_v_lbl_party igs_lookup_values.meaning%TYPE;
40: g_v_lbl_pay igs_lookup_values.meaning%TYPE;
41: g_v_lbl_vchr igs_lookup_values.meaning%TYPE;

Line 38: g_v_lbl_test_run igs_lookup_values.meaning%TYPE;

34: g_v_lbl_create_suppl igs_lookup_values.meaning%TYPE;
35: g_v_lbl_suppl_type igs_lookup_values.meaning%TYPE;
36: g_v_lbl_pay_grp igs_lookup_values.meaning%TYPE;
37: g_v_lbl_inv_term igs_lookup_values.meaning%TYPE;
38: g_v_lbl_test_run igs_lookup_values.meaning%TYPE;
39: g_v_lbl_party igs_lookup_values.meaning%TYPE;
40: g_v_lbl_pay igs_lookup_values.meaning%TYPE;
41: g_v_lbl_vchr igs_lookup_values.meaning%TYPE;
42: g_v_lbl_status igs_lookup_values.meaning%TYPE;

Line 39: g_v_lbl_party igs_lookup_values.meaning%TYPE;

35: g_v_lbl_suppl_type igs_lookup_values.meaning%TYPE;
36: g_v_lbl_pay_grp igs_lookup_values.meaning%TYPE;
37: g_v_lbl_inv_term igs_lookup_values.meaning%TYPE;
38: g_v_lbl_test_run igs_lookup_values.meaning%TYPE;
39: g_v_lbl_party igs_lookup_values.meaning%TYPE;
40: g_v_lbl_pay igs_lookup_values.meaning%TYPE;
41: g_v_lbl_vchr igs_lookup_values.meaning%TYPE;
42: g_v_lbl_status igs_lookup_values.meaning%TYPE;
43: g_v_lbl_todo igs_lookup_values.meaning%TYPE;

Line 40: g_v_lbl_pay igs_lookup_values.meaning%TYPE;

36: g_v_lbl_pay_grp igs_lookup_values.meaning%TYPE;
37: g_v_lbl_inv_term igs_lookup_values.meaning%TYPE;
38: g_v_lbl_test_run igs_lookup_values.meaning%TYPE;
39: g_v_lbl_party igs_lookup_values.meaning%TYPE;
40: g_v_lbl_pay igs_lookup_values.meaning%TYPE;
41: g_v_lbl_vchr igs_lookup_values.meaning%TYPE;
42: g_v_lbl_status igs_lookup_values.meaning%TYPE;
43: g_v_lbl_todo igs_lookup_values.meaning%TYPE;
44: g_v_lbl_offset igs_lookup_values.meaning%TYPE;

Line 41: g_v_lbl_vchr igs_lookup_values.meaning%TYPE;

37: g_v_lbl_inv_term igs_lookup_values.meaning%TYPE;
38: g_v_lbl_test_run igs_lookup_values.meaning%TYPE;
39: g_v_lbl_party igs_lookup_values.meaning%TYPE;
40: g_v_lbl_pay igs_lookup_values.meaning%TYPE;
41: g_v_lbl_vchr igs_lookup_values.meaning%TYPE;
42: g_v_lbl_status igs_lookup_values.meaning%TYPE;
43: g_v_lbl_todo igs_lookup_values.meaning%TYPE;
44: g_v_lbl_offset igs_lookup_values.meaning%TYPE;
45: g_v_lbl_transferred igs_lookup_values.meaning%TYPE;

Line 42: g_v_lbl_status igs_lookup_values.meaning%TYPE;

38: g_v_lbl_test_run igs_lookup_values.meaning%TYPE;
39: g_v_lbl_party igs_lookup_values.meaning%TYPE;
40: g_v_lbl_pay igs_lookup_values.meaning%TYPE;
41: g_v_lbl_vchr igs_lookup_values.meaning%TYPE;
42: g_v_lbl_status igs_lookup_values.meaning%TYPE;
43: g_v_lbl_todo igs_lookup_values.meaning%TYPE;
44: g_v_lbl_offset igs_lookup_values.meaning%TYPE;
45: g_v_lbl_transferred igs_lookup_values.meaning%TYPE;
46: g_n_org_id igs_fi_control.ap_org_id%TYPE;

Line 43: g_v_lbl_todo igs_lookup_values.meaning%TYPE;

39: g_v_lbl_party igs_lookup_values.meaning%TYPE;
40: g_v_lbl_pay igs_lookup_values.meaning%TYPE;
41: g_v_lbl_vchr igs_lookup_values.meaning%TYPE;
42: g_v_lbl_status igs_lookup_values.meaning%TYPE;
43: g_v_lbl_todo igs_lookup_values.meaning%TYPE;
44: g_v_lbl_offset igs_lookup_values.meaning%TYPE;
45: g_v_lbl_transferred igs_lookup_values.meaning%TYPE;
46: g_n_org_id igs_fi_control.ap_org_id%TYPE;
47: g_v_cur_code igs_fi_control.currency_cd%TYPE;

Line 44: g_v_lbl_offset igs_lookup_values.meaning%TYPE;

40: g_v_lbl_pay igs_lookup_values.meaning%TYPE;
41: g_v_lbl_vchr igs_lookup_values.meaning%TYPE;
42: g_v_lbl_status igs_lookup_values.meaning%TYPE;
43: g_v_lbl_todo igs_lookup_values.meaning%TYPE;
44: g_v_lbl_offset igs_lookup_values.meaning%TYPE;
45: g_v_lbl_transferred igs_lookup_values.meaning%TYPE;
46: g_n_org_id igs_fi_control.ap_org_id%TYPE;
47: g_v_cur_code igs_fi_control.currency_cd%TYPE;
48: g_v_sup_num po_vendors.segment1%TYPE;

Line 45: g_v_lbl_transferred igs_lookup_values.meaning%TYPE;

41: g_v_lbl_vchr igs_lookup_values.meaning%TYPE;
42: g_v_lbl_status igs_lookup_values.meaning%TYPE;
43: g_v_lbl_todo igs_lookup_values.meaning%TYPE;
44: g_v_lbl_offset igs_lookup_values.meaning%TYPE;
45: g_v_lbl_transferred igs_lookup_values.meaning%TYPE;
46: g_n_org_id igs_fi_control.ap_org_id%TYPE;
47: g_v_cur_code igs_fi_control.currency_cd%TYPE;
48: g_v_sup_num po_vendors.segment1%TYPE;
49: g_v_sup_name po_vendors.vendor_name%TYPE;

Line 50: g_v_pay_rfnd_vchr igs_lookup_values.lookup_code%TYPE;

46: g_n_org_id igs_fi_control.ap_org_id%TYPE;
47: g_v_cur_code igs_fi_control.currency_cd%TYPE;
48: g_v_sup_num po_vendors.segment1%TYPE;
49: g_v_sup_name po_vendors.vendor_name%TYPE;
50: g_v_pay_rfnd_vchr igs_lookup_values.lookup_code%TYPE;
51: g_v_dflt_sup_site igs_fi_control.dflt_supplier_site_name%TYPE;
52: g_v_supplier_type po_vendors.vendor_type_lookup_code%TYPE;
53: g_v_ven_num_code financials_system_params_all.user_defined_vendor_num_code%TYPE;
54: g_v_create_supplier VARCHAR2(1);

Line 92: l_v_status igs_lookup_values.meaning%TYPE;

88: WHERE party_id = cp_n_party_id;
89:
90: l_n_party_num hz_parties.party_number%TYPE;
91:
92: l_v_status igs_lookup_values.meaning%TYPE;
93:
94: BEGIN
95: l_n_party_num := NULL;
96: OPEN c_party(p_n_party_id);

Line 345: CURSOR c_po_lkp(cp_v_lookup_type igs_lookup_values.lookup_type%TYPE,

341:
342: l_c_pers_id_grp c_pers_id_grp%ROWTYPE;
343:
344: -- Cursor for validating a valid lookup code for a lookup type in PO Lookups
345: CURSOR c_po_lkp(cp_v_lookup_type igs_lookup_values.lookup_type%TYPE,
346: cp_v_lookup_code igs_lookup_values.lookup_code%TYPE) IS
347: SELECT displayed_field meaning, inactive_date
348: FROM po_lookup_codes
349: WHERE lookup_type = cp_v_lookup_type

Line 346: cp_v_lookup_code igs_lookup_values.lookup_code%TYPE) IS

342: l_c_pers_id_grp c_pers_id_grp%ROWTYPE;
343:
344: -- Cursor for validating a valid lookup code for a lookup type in PO Lookups
345: CURSOR c_po_lkp(cp_v_lookup_type igs_lookup_values.lookup_type%TYPE,
346: cp_v_lookup_code igs_lookup_values.lookup_code%TYPE) IS
347: SELECT displayed_field meaning, inactive_date
348: FROM po_lookup_codes
349: WHERE lookup_type = cp_v_lookup_type
350: AND lookup_code = cp_v_lookup_code;

Line 1234: l_v_inv_lkp igs_lookup_values.lookup_code%TYPE;

1230: SELECT AP_INVOICES_INTERFACE_S.NEXTVAL
1231: FROM dual;
1232:
1233: l_n_inv_id ap_invoices_interface.invoice_id%TYPE;
1234: l_v_inv_lkp igs_lookup_values.lookup_code%TYPE;
1235: l_n_rfnd_amt NUMBER := 0;
1236: BEGIN
1237:
1238: -- Get the new Invoice Id from the AP_INVOICES_INTERFACE_S sequence