APPS.LNS_APPROVAL_ACTION_PUB dependencies on LNS_UTILITY_PUB

Line 632: OPEN C_Get_Resource_Id(LNS_UTILITY_PUB.Created_By);

628: END IF;
629: CLOSE C_Get_Loan_Info;
630: l_prev_loan_status := l_status;
631:
632: OPEN C_Get_Resource_Id(LNS_UTILITY_PUB.Created_By);
633: FETCH C_Get_Resource_Id INTO l_resource_id;
634: CLOSE C_Get_Resource_Id;
635:
636: -- validate status transitions

Line 967: ,P_LAST_UPDATED_BY => LNS_UTILITY_PUB.LAST_UPDATED_BY

963: ,P_ACTIVE_FLAG => null
964: ,P_BILLED_FLAG => 'N' -- Make BilledFlag to 'N'
965: ,P_FEE_WAIVABLE_FLAG => null
966: ,P_WAIVED_AMOUNT => null
967: ,P_LAST_UPDATED_BY => LNS_UTILITY_PUB.LAST_UPDATED_BY
968: ,P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.LAST_UPDATE_DATE
969: ,P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
970: ,P_PROGRAM_ID => null
971: ,P_REQUEST_ID => null

Line 968: ,P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.LAST_UPDATE_DATE

964: ,P_BILLED_FLAG => 'N' -- Make BilledFlag to 'N'
965: ,P_FEE_WAIVABLE_FLAG => null
966: ,P_WAIVED_AMOUNT => null
967: ,P_LAST_UPDATED_BY => LNS_UTILITY_PUB.LAST_UPDATED_BY
968: ,P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.LAST_UPDATE_DATE
969: ,P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
970: ,P_PROGRAM_ID => null
971: ,P_REQUEST_ID => null
972: ,P_OBJECT_VERSION_NUMBER => null);

Line 969: ,P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

965: ,P_FEE_WAIVABLE_FLAG => null
966: ,P_WAIVED_AMOUNT => null
967: ,P_LAST_UPDATED_BY => LNS_UTILITY_PUB.LAST_UPDATED_BY
968: ,P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.LAST_UPDATE_DATE
969: ,P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
970: ,P_PROGRAM_ID => null
971: ,P_REQUEST_ID => null
972: ,P_OBJECT_VERSION_NUMBER => null);
973: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, ' fee_schedule_id : '|| l_fee_tbl(l_Count).fee_schedule_id||' updated succesfully ');

Line 1075: IF (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' OR lns_utility_pub.IS_ENCUM_FIN_ENABLED = 'Y') THEN

1071: END IF;
1072:
1073: -- Bug#9685116 - Only for federal/encumbrance customers, it should do the 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

Line 1112: END IF; -- if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y')

1108: end if;
1109:
1110: end if;
1111: end;
1112: END IF; -- if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y')
1113:
1114: END IF;
1115:
1116: --if loan status is cancelled, the funding api to cancel remaining disbursements would have updated loan header already no need to do it again