APPS.PA_BUDGET_FUND_PKG dependencies on PA_IMPLEMENTATIONS_ALL

Line 38: g_org_id pa_implementations_all.org_id%type; --Bug 6524116

34: g_procedure_name VARCHAR2(30);
35: g_debug_mode VARCHAR2(10);
36: g_draft_bvid pa_budget_versions.budget_version_id%type;
37: g_project_id pa_projects_all.project_id%type;
38: g_org_id pa_implementations_all.org_id%type; --Bug 6524116
39:
40: -- This is an autonomous procedure ...
41: PROCEDURE Update_bc_packets_fail(p_bud_ver_id IN NUMBER,
42: p_status_code IN VARCHAR2);

Line 89: l_set_of_books_id pa_implementations_all.set_of_books_id%type;

85: l_funds_chk_rsrv_status VARCHAR2(1);
86:
87:
88: l_header_id number; --IGC_CC_INTERFACE.cc_header_id%TYPE ;
89: l_set_of_books_id pa_implementations_all.set_of_books_id%type;
90: l_category_name gl_je_categories.user_je_category_name%type ;
91: l_source_name gl_je_sources.user_je_source_name%type;
92: l_batch_line_num number; --IGC_CC_INTERFACE.batch_line_num%TYPE ;
93: l_code_combination_id gl_code_combinations.code_combination_id%TYPE ;

Line 121: FROM PA_IMPLEMENTATIONS_all IMP, GL_SETS_OF_BOOKS SOB

117: x_return_status := FND_API.G_RET_STS_SUCCESS;
118:
119: SELECT imp.set_of_books_id, sob.currency_code, SOB.PERIOD_SET_NAME
120: INTO l_set_of_books_id, l_currency_code, l_period_set_name
121: FROM PA_IMPLEMENTATIONS_all IMP, GL_SETS_OF_BOOKS SOB
122: where IMP.set_of_books_id = SOB.set_of_books_id
123: AND imp.org_id = nvl(g_org_id, imp.org_id);
124:
125: select user_je_category_name

Line 782: l_sob_id pa_implementations_all.set_of_books_id%TYPE;

778: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
779: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;
780: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
781:
782: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
783:
784: BEGIN
785: g_procedure_name := 'Establish_bc_balances';
786: log_message('Establish_bc_balances:Start');

Line 793: select to_number(set_of_books_id) into l_sob_id from pa_implementations_all

789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790:
791: log_message('Establish_bc_balances: Get SOB_ID');
792:
793: select to_number(set_of_books_id) into l_sob_id from pa_implementations_all
794: where org_id = g_org_id;
795:
796: log_message('Establish_bc_balances: SOB_ID:'||l_sob_id);
797: