DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on MTL_PARAMETERS

Line 953: cursor c_mtl_parameters(cp_organization_id number) is

949: select receiving_account_id
950: from rcv_parameters
951: Where organization_id = cp_organization_id;
952:
953: cursor c_mtl_parameters(cp_organization_id number) is
954: select ap_accrual_account
955: from mtl_parameters
956: where organization_id = cp_organization_id;
957:

Line 955: from mtl_parameters

951: Where organization_id = cp_organization_id;
952:
953: cursor c_mtl_parameters(cp_organization_id number) is
954: select ap_accrual_account
955: from mtl_parameters
956: where organization_id = cp_organization_id;
957:
958: cursor c_po_distributions_all(cp_po_distribution_id number) is
959: select accrual_account_id

Line 993: r_mtl_parameters c_mtl_parameters%rowtype;

989:
990:
991: r_ja_in_hr_organization_units c_ja_in_hr_organization_units%rowtype;
992: r_ja_in_hr_organization_units1 c_ja_in_hr_organization_units%rowtype;
993: r_mtl_parameters c_mtl_parameters%rowtype;
994: r_po_distributions_all c_po_distributions_all%rowtype;
995: r_po_distributions_all_1 c_po_distributions_all_1%rowtype;
996: r_rcv_parameters c_rcv_parameters%rowtype;
997: r_mtl_interorg_parameters c_mtl_interorg_parameters%rowtype;

Line 1060: open c_mtl_parameters(p_organization_id);

1056:
1057: p_receiving_account_id := r_rcv_parameters.receiving_account_id;
1058:
1059: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1060: open c_mtl_parameters(p_organization_id);
1061: fetch c_mtl_parameters into r_mtl_parameters;
1062: close c_mtl_parameters;
1063:
1064: p_ap_accrual_account := r_mtl_parameters.ap_accrual_account;

Line 1061: fetch c_mtl_parameters into r_mtl_parameters;

1057: p_receiving_account_id := r_rcv_parameters.receiving_account_id;
1058:
1059: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1060: open c_mtl_parameters(p_organization_id);
1061: fetch c_mtl_parameters into r_mtl_parameters;
1062: close c_mtl_parameters;
1063:
1064: p_ap_accrual_account := r_mtl_parameters.ap_accrual_account;
1065:

Line 1062: close c_mtl_parameters;

1058:
1059: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1060: open c_mtl_parameters(p_organization_id);
1061: fetch c_mtl_parameters into r_mtl_parameters;
1062: close c_mtl_parameters;
1063:
1064: p_ap_accrual_account := r_mtl_parameters.ap_accrual_account;
1065:
1066:

Line 1064: p_ap_accrual_account := r_mtl_parameters.ap_accrual_account;

1060: open c_mtl_parameters(p_organization_id);
1061: fetch c_mtl_parameters into r_mtl_parameters;
1062: close c_mtl_parameters;
1063:
1064: p_ap_accrual_account := r_mtl_parameters.ap_accrual_account;
1065:
1066:
1067: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1068: if p_po_distribution_id is not null then

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

1626: elsif p_ap_accrual_account is null then
1627:
1628: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
1629: p_process_flag := 'E';
1630: p_process_message := 'AP Accrual Account is not defined in mtl_parameters for the organization.';
1631: goto exit_from_procedure;
1632:
1633: end if; /* p_receipt_source_code = 'INTERNAL ORDER' */
1634: