DBA Data[Home] [Help]

APPS.IGS_FI_PRC_APINT dependencies on IGS_FI_CONTROL

Line 46: g_n_org_id igs_fi_control.ap_org_id%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;
50: g_v_pay_rfnd_vchr igs_lookup_values.lookup_code%TYPE;

Line 47: g_v_cur_code igs_fi_control.currency_cd%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;
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;

Line 51: g_v_dflt_sup_site igs_fi_control.dflt_supplier_site_name%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);
55: g_b_data_found BOOLEAN;

Line 325: FROM igs_fi_control;

321: -- Cursor for fetching the Org Id and the default
322: -- supplier site name
323: CURSOR c_ctrl IS
324: SELECT ap_org_id, dflt_supplier_site_name
325: FROM igs_fi_control;
326:
327: -- Cursor for selecting the party number from hz_parties
328: -- for a party id
329: CURSOR c_party(cp_n_party_id hz_parties.party_id%TYPE) IS

Line 375: l_v_rfnd_destination igs_fi_control.rfnd_destination%TYPE;

371: CURSOR c_fnd_prod IS
372: SELECT multi_org_flag
373: FROM fnd_product_groups;
374:
375: l_v_rfnd_destination igs_fi_control.rfnd_destination%TYPE;
376: l_c_ap_term c_ap_term%ROWTYPE;
377: l_c_fnd_prod c_fnd_prod%ROWTYPE;
378: l_v_curr_desc igs_fi_control_v.name%TYPE;
379: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 378: l_v_curr_desc igs_fi_control_v.name%TYPE;

374:
375: l_v_rfnd_destination igs_fi_control.rfnd_destination%TYPE;
376: l_c_ap_term c_ap_term%ROWTYPE;
377: l_c_fnd_prod c_fnd_prod%ROWTYPE;
378: l_v_curr_desc igs_fi_control_v.name%TYPE;
379: l_v_message_name fnd_new_messages.message_name%TYPE;
380: l_b_term_flag BOOLEAN := TRUE;
381: l_b_party_flag BOOLEAN := TRUE;
382: l_b_pers_grp_flag BOOLEAN := TRUE;

Line 387: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;

383: l_b_sup_type_flag BOOLEAN := TRUE;
384: l_b_inv_pay_grp_flag BOOLEAN := TRUE;
385: l_b_inv_pay_term_flag BOOLEAN := TRUE;
386: l_b_val_parm BOOLEAN := TRUE;
387: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
388: l_b_run_process BOOLEAN := TRUE;
389:
390: BEGIN
391: