APPS.PQH_APPLY_BUDGET dependencies on PQH_TRANSACTION_CATEGORIES

Line 19: g_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;

15: g_table_route_id_wpr NUMBER;
16: g_table_route_id_wst NUMBER;
17: g_table_route_id_wel NUMBER;
18: g_table_route_id_wfs NUMBER;
19: g_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
20: g_worksheet_name pqh_worksheets.worksheet_name%TYPE;
21: g_worksheet_id pqh_worksheets.worksheet_id%TYPE;
22: g_error_exception exception;
23: g_curr_wks_dtl_level NUMBER;

Line 2413: l_transaction_categories_rec pqh_transaction_categories%ROWTYPE;

2409: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2410: l_gl_validation varchar2(30);
2411: l_req number(9);
2412: l_transaction_category_id number;
2413: l_transaction_categories_rec pqh_transaction_categories%ROWTYPE;
2414: l_pqh_worksheets_rec pqh_worksheets%ROWTYPE;
2415: l_txn_state varchar2(10);
2416:
2417:

Line 2425: FROM pqh_transaction_categories

2421: WHERE worksheet_detail_id = p_transaction_id;
2422:
2423: CURSOR csr_txn_cat_id(p_transaction_category_id in number) IS
2424: SELECT *
2425: FROM pqh_transaction_categories
2426: WHERE transaction_category_id = p_transaction_category_id;
2427:
2428: CURSOR csr_wks(p_worksheet_id IN NUMBER) IS
2429: SELECT *

Line 2916: l_transaction_categories_rec pqh_transaction_categories%ROWTYPE;

2912:
2913: l_proc varchar2(72) := g_package||'get_txn_state';
2914: l_return_state varchar2(10);
2915:
2916: l_transaction_categories_rec pqh_transaction_categories%ROWTYPE;
2917:
2918: CURSOR csr_txn_cat_id IS
2919: SELECT *
2920: FROM pqh_transaction_categories

Line 2920: FROM pqh_transaction_categories

2916: l_transaction_categories_rec pqh_transaction_categories%ROWTYPE;
2917:
2918: CURSOR csr_txn_cat_id IS
2919: SELECT *
2920: FROM pqh_transaction_categories
2921: WHERE transaction_category_id = p_transaction_category_id;
2922:
2923:
2924: BEGIN

Line 3093: cursor c3 is select name from pqh_transaction_categories

3089: where worksheet_id = l_worksheet_id;
3090: cursor c2 is select budget_name,budgeted_entity_cd,budget_style_cd,budget_start_date,budget_end_date
3091: from pqh_budgets
3092: where budget_id = l_budget_id;
3093: cursor c3 is select name from pqh_transaction_categories
3094: where transaction_category_id = l_tran_cat_id;
3095: cursor c4 is select name from hr_all_organization_units_tl
3096: where organization_id = l_organization_id
3097: and language = userenv('LANG');

Line 3533: p_transaction_category_id IN pqh_transaction_categories.transaction_category_id%TYPE,

3529: --------------------------------------------------------------------------------------------------------------
3530:
3531: FUNCTION set_status
3532: (
3533: p_transaction_category_id IN pqh_transaction_categories.transaction_category_id%TYPE,
3534: p_transaction_id IN pqh_worksheets.worksheet_id%TYPE,
3535: p_status IN pqh_worksheets.transaction_status%TYPE
3536: ) RETURN varchar2 IS
3537: /*