APPS.LNS_APPROVAL_ACTION_PUB dependencies on LNS_DISTRIBUTIONS

Line 498: from lns_distributions

494: CURSOR C_Get_Distribution (X_Loan_Id NUMBER, X_Acct_Type VARCHAR2, X_Acct_Name VARCHAR2, X_Line_Type VARCHAR2) IS
495: select DISTRIBUTION_ID
496: ,CODE_COMBINATION_ID
497: ,DISTRIBUTION_PERCENT
498: from lns_distributions
499: where LOAN_ID = x_loan_id
500: and account_type = x_acct_type
501: and account_name = x_acct_name
502: and line_type = x_line_type

Line 550: FROM lns_distributions dist

546: loan.loan_id = P_LOAN_ID;
547:
548: CURSOR cur_getApprDistCount(C_LOAN_ID Number) IS
549: SELECT count(1)
550: FROM lns_distributions dist
551: WHERE dist.loan_id = C_LOAN_ID
552: AND dist.activity = 'LNS_APPROVAL';
553:
554: cursor c_get_bill_opt(p_loan_id number) is

Line 1062: Lns_distributions_pub.defaultDistributions(p_api_version => 1.0

1058:
1059: IF (l_appr_dist_cnt < 2) THEN
1060:
1061: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - before default distributions');
1062: Lns_distributions_pub.defaultDistributions(p_api_version => 1.0
1063: ,p_init_msg_list => FND_API.G_TRUE
1064: ,p_commit => FND_API.G_FALSE
1065: ,p_loan_id => l_loan_header_rec.loan_id
1066: ,p_loan_class_code => l_loan_class_code

Line 1078: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'calling lns_distributions_pub.budgetary_control');

1074: -- Bug#10126147 - For Encumbrance also
1075: IF (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' OR lns_utility_pub.IS_ENCUM_FIN_ENABLED = 'Y') THEN
1076: begin
1077: l_last_api_called := null;
1078: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'calling lns_distributions_pub.budgetary_control');
1079: lns_distributions_pub.budgetary_control(p_init_msg_list => FND_API.G_FALSE
1080: ,p_commit => FND_API.G_FALSE
1081: ,p_loan_id => l_approval_action_rec.loan_id
1082: ,p_budgetary_control_mode => 'R'

Line 1079: lns_distributions_pub.budgetary_control(p_init_msg_list => FND_API.G_FALSE

1075: IF (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' OR lns_utility_pub.IS_ENCUM_FIN_ENABLED = 'Y') THEN
1076: begin
1077: l_last_api_called := null;
1078: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'calling lns_distributions_pub.budgetary_control');
1079: lns_distributions_pub.budgetary_control(p_init_msg_list => FND_API.G_FALSE
1080: ,p_commit => FND_API.G_FALSE
1081: ,p_loan_id => l_approval_action_rec.loan_id
1082: ,p_budgetary_control_mode => 'R'
1083: ,x_budgetary_status_code => l_budgetary_status

Line 1087: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to Lns_distributions_pub.budgetary_control return status ' || x_return_status);

1083: ,x_budgetary_status_code => l_budgetary_status
1084: ,x_return_status => x_return_status
1085: ,x_msg_count => x_msg_count
1086: ,x_msg_data => x_msg_data);
1087: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to Lns_distributions_pub.budgetary_control return status ' || x_return_status);
1088: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'l_budgetary_status' || l_budgetary_status);
1089: --FND_MSG_PUB.initialize;
1090: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1091: RAISE FND_API.G_EXC_ERROR;

Line 1741: LNS_DISTRIBUTIONS_PUB.createDistrForAddRec(P_API_VERSION => 1.0

1737: l_version_number;
1738: close loan_info_cur;
1739:
1740: -- create distributions for new approved additional receivable?
1741: LNS_DISTRIBUTIONS_PUB.createDistrForAddRec(P_API_VERSION => 1.0
1742: ,P_INIT_MSG_LIST => FND_API.G_TRUE
1743: ,P_COMMIT => FND_API.G_FALSE
1744: ,P_LOAN_ID => l_loan_id
1745: ,P_LOAN_LINE_ID => P_LOAN_LINE_ID