DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on MTL_PARAMETERS

Line 1096: cursor c_mtl_parameters(cp_organization_id number) is

1092: select receiving_account_id
1093: from rcv_parameters
1094: Where organization_id = cp_organization_id;
1095:
1096: cursor c_mtl_parameters(cp_organization_id number) is
1097: select ap_accrual_account
1098: from mtl_parameters
1099: where organization_id = cp_organization_id;
1100:

Line 1098: from mtl_parameters

1094: Where organization_id = cp_organization_id;
1095:
1096: cursor c_mtl_parameters(cp_organization_id number) is
1097: select ap_accrual_account
1098: from mtl_parameters
1099: where organization_id = cp_organization_id;
1100:
1101: cursor c_po_distributions_all(cp_po_distribution_id number) is
1102: select accrual_account_id

Line 1136: r_mtl_parameters c_mtl_parameters%rowtype;

1132:
1133:
1134: r_ja_in_hr_organization_units c_ja_in_hr_organization_units%rowtype;
1135: r_ja_in_hr_organization_units1 c_ja_in_hr_organization_units%rowtype;
1136: r_mtl_parameters c_mtl_parameters%rowtype;
1137: r_po_distributions_all c_po_distributions_all%rowtype;
1138: r_po_distributions_all_1 c_po_distributions_all_1%rowtype;
1139: r_rcv_parameters c_rcv_parameters%rowtype;
1140: r_mtl_interorg_parameters c_mtl_interorg_parameters%rowtype;

Line 1203: open c_mtl_parameters(p_organization_id);

1199:
1200: p_receiving_account_id := r_rcv_parameters.receiving_account_id;
1201:
1202: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1203: open c_mtl_parameters(p_organization_id);
1204: fetch c_mtl_parameters into r_mtl_parameters;
1205: close c_mtl_parameters;
1206:
1207: p_ap_accrual_account := r_mtl_parameters.ap_accrual_account;

Line 1204: fetch c_mtl_parameters into r_mtl_parameters;

1200: p_receiving_account_id := r_rcv_parameters.receiving_account_id;
1201:
1202: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1203: open c_mtl_parameters(p_organization_id);
1204: fetch c_mtl_parameters into r_mtl_parameters;
1205: close c_mtl_parameters;
1206:
1207: p_ap_accrual_account := r_mtl_parameters.ap_accrual_account;
1208:

Line 1205: close c_mtl_parameters;

1201:
1202: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1203: open c_mtl_parameters(p_organization_id);
1204: fetch c_mtl_parameters into r_mtl_parameters;
1205: close c_mtl_parameters;
1206:
1207: p_ap_accrual_account := r_mtl_parameters.ap_accrual_account;
1208:
1209:

Line 1207: p_ap_accrual_account := r_mtl_parameters.ap_accrual_account;

1203: open c_mtl_parameters(p_organization_id);
1204: fetch c_mtl_parameters into r_mtl_parameters;
1205: close c_mtl_parameters;
1206:
1207: p_ap_accrual_account := r_mtl_parameters.ap_accrual_account;
1208:
1209:
1210: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1211: if p_po_distribution_id is not null then

Line 1929: p_process_message := 'AP Accrual Account is not defined in mtl_parameters for the organization.';

1925: elsif p_ap_accrual_account is null then
1926:
1927: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
1928: p_process_flag := 'E';
1929: p_process_message := 'AP Accrual Account is not defined in mtl_parameters for the organization.';
1930: goto exit_from_procedure;
1931:
1932: end if; /* p_receipt_source_code = 'INTERNAL ORDER' */
1933: