APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_RUNS_ALL

Line 4312: INSERT INTO pa_alloc_runs_all (

4308: Select pa_alloc_runs_s.nextval
4309: Into x_run_id
4310: From dual;
4311: End If;
4312: INSERT INTO pa_alloc_runs_all (
4313: RUN_ID
4314: , RULE_ID
4315: , RUN_PERIOD
4316: , EXPND_ITEM_DATE

Line 10003: select run_id from pa_alloc_runs_all

9999: )
10000: IS
10001: CURSOR get_run_id
10002: IS
10003: select run_id from pa_alloc_runs_all
10004: where rule_id = p_rule_id
10005: and run_status = 'DL';
10006: l_run_id NUMBER;
10007: v_debug_mode VARCHAR2(2);

Line 10337: ( p_run_id IN pa_alloc_runs_all.run_id%TYPE

10333: --This procedure is called from PA_CAP_INT_PVT. Generate_cap_interest when release button is pressed on the
10334: --Allocation form(when form is accessed in the context of capitalized interest) or when auto release flag is
10335: --passed Y
10336: PROCEDURE release_capint_txns
10337: ( p_run_id IN pa_alloc_runs_all.run_id%TYPE
10338: ,x_return_status OUT NOCOPY VARCHAR2
10339: ,x_msg_count OUT NOCOPY NUMBER
10340: ,x_msg_data OUT NOCOPY VARCHAR2
10341: )

Line 10444: ( p_run_id IN pa_alloc_runs_all.run_id%TYPE

10440: --This procedure deletes the source details for each capital interest transaction. This procedure will
10441: --be called from delete_alloc_run api when the DELETE button is pressed to delete a capital interest
10442: --batch
10443: PROCEDURE delete_cint_source_dets
10444: ( p_run_id IN pa_alloc_runs_all.run_id%TYPE
10445: ,x_return_status OUT NOCOPY VARCHAR2
10446: ,x_msg_count OUT NOCOPY NUMBER
10447: ,x_msg_data OUT NOCOPY VARCHAR2
10448: )