APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_RUNS_ALL

Line 4289: INSERT INTO pa_alloc_runs_all (

4285: Select pa_alloc_runs_s.nextval
4286: Into x_run_id
4287: From dual;
4288: End If;
4289: INSERT INTO pa_alloc_runs_all (
4290: RUN_ID
4291: , RULE_ID
4292: , RUN_PERIOD
4293: , EXPND_ITEM_DATE

Line 9898: select run_id from pa_alloc_runs_all

9894: )
9895: IS
9896: CURSOR get_run_id
9897: IS
9898: select run_id from pa_alloc_runs_all
9899: where rule_id = p_rule_id
9900: and run_status = 'DL';
9901: l_run_id NUMBER;
9902: v_debug_mode VARCHAR2(2);

Line 10232: ( p_run_id IN pa_alloc_runs_all.run_id%TYPE

10228: --This procedure is called from PA_CAP_INT_PVT. Generate_cap_interest when release button is pressed on the
10229: --Allocation form(when form is accessed in the context of capitalized interest) or when auto release flag is
10230: --passed Y
10231: PROCEDURE release_capint_txns
10232: ( p_run_id IN pa_alloc_runs_all.run_id%TYPE
10233: ,x_return_status OUT NOCOPY VARCHAR2
10234: ,x_msg_count OUT NOCOPY NUMBER
10235: ,x_msg_data OUT NOCOPY VARCHAR2
10236: )

Line 10339: ( p_run_id IN pa_alloc_runs_all.run_id%TYPE

10335: --This procedure deletes the source details for each capital interest transaction. This procedure will
10336: --be called from delete_alloc_run api when the DELETE button is pressed to delete a capital interest
10337: --batch
10338: PROCEDURE delete_cint_source_dets
10339: ( p_run_id IN pa_alloc_runs_all.run_id%TYPE
10340: ,x_return_status OUT NOCOPY VARCHAR2
10341: ,x_msg_count OUT NOCOPY NUMBER
10342: ,x_msg_data OUT NOCOPY VARCHAR2
10343: )