eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PPMV4_SS dependencies on PAY_PSS_TRANSACTION_STEPS

Line 33: from pay_pss_transaction_steps pts,

29: into l_dummy
30: from sys.dual
31: where not exists
32: (select null
33: from pay_pss_transaction_steps pts,
34: pay_org_payment_methods_f opm,
35: pay_payment_types ppt
36: where pts.transaction_step_id = p_transaction_step_id
37: and opm.org_payment_method_id = pts.org_payment_method_id

Line 74: from pay_pss_transaction_steps ppts

70: ) is
71: cursor csr_ppm_info(p_transaction_id in number) is
72: select ppts.transaction_step_id
73: , ppts.state
74: from pay_pss_transaction_steps ppts
75: where ppts.transaction_id = p_transaction_id
76: and ppts.state <> C_STATE_FREED
77: ;
78: --

Line 257: from pay_pss_transaction_steps p

253: select p.state
254: , p.amount_type
255: into l_state
256: , l_amount_type
257: from pay_pss_transaction_steps p
258: where p.transaction_step_id = l_txstepid;
259: if l_state = C_STATE_EXISTING and
260: l_amount_type <> C_REMAINING_PAY then
261: l_state := C_STATE_UPDATED;

Line 284: update pay_pss_transaction_steps p

280: end if;
281: --
282: -- Update the lowest priority PPM.
283: --
284: update pay_pss_transaction_steps p
285: set p.amount_type = C_REMAINING_PAY
286: , p.amount = 100
287: , p.state = l_state
288: where transaction_step_id = l_txstepid

Line 2204: from pay_pss_transaction_steps

2200: ) is
2201: select transaction_step_id
2202: , state
2203: , logical_priority
2204: from pay_pss_transaction_steps
2205: where transaction_id = p_transaction_id;
2206: --
2207: l_state varchar2(2000);
2208: l_priority number;

Line 2302: l_run_type_id pay_pss_transaction_steps.run_type_id%type;

2298: l_priorities pay_ppmv4_utils_ss.t_boolean_tbl;
2299: i number;
2300: l_proc varchar2(2000) := g_package||'alloc_real_priorities';
2301:
2302: l_run_type_id pay_pss_transaction_steps.run_type_id%type;
2303:
2304: --
2305: -- cursor to fetch the run_type_id
2306: --

Line 2310: from pay_pss_transaction_steps ppts

2306: --
2307:
2308: cursor csr_run_type_id(p_transaction_id in number) is
2309: select distinct ppts.run_type_id
2310: from pay_pss_transaction_steps ppts
2311: where ppts.transaction_id = p_transaction_id;
2312:
2313: begin
2314: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'ENTER', 0);

Line 2372: from pay_pss_transaction_steps p

2368: --
2369: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'O_REAL_PRIORITY', 20);
2370: select p.o_real_priority
2371: into l_o_priority
2372: from pay_pss_transaction_steps p
2373: where p.transaction_step_id = l_txstepid
2374: ;
2375:
2376: --

Line 2412: update pay_pss_transaction_steps p

2408: --
2409: -- Write back the real priority value.
2410: --
2411: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'WRITE_PRIORITY', 40);
2412: update pay_pss_transaction_steps p
2413: set p.real_priority = l_priority
2414: where p.transaction_step_id = l_txstepid;
2415: --
2416:

Line 2455: pay_pss_transaction_steps pps

2451: -- Curosor to get the actual percentage/amount of the ppm.
2452: cursor fetch_org_values is
2453: select ppm.AMOUNT, ppm.PERCENTAGE
2454: from pay_personal_payment_methods_f ppm,
2455: pay_pss_transaction_steps pps
2456: where pps.transaction_step_id = p_transaction_step_id
2457: and pps.PERSONAL_PAYMENT_METHOD_ID = ppm.PERSONAL_PAYMENT_METHOD_ID
2458: and pps.ASSIGNMENT_ID= ppm.ASSIGNMENT_ID
2459: and pps.ORG_PAYMENT_METHOD_ID = ppm.ORG_PAYMENT_METHOD_ID

Line 2478: from pay_pss_transaction_steps p

2474: , l_o_logical_priority
2475: , l_state
2476: , l_amount_type
2477: , l_amount
2478: from pay_pss_transaction_steps p
2479: where p.transaction_step_id = p_transaction_step_id;
2480: --
2481: -- Only need to do something if the new logical priority differs
2482: -- from the current logical priority.

Line 2578: update pay_pss_transaction_steps p

2574: end if;
2575: --
2576: -- Make and Commit the changes.
2577: --
2578: update pay_pss_transaction_steps p
2579: set p.amount = l_amount
2580: , p.amount_type = l_amount_type
2581: , p.logical_priority = p_logical_priority
2582: , p.state = l_state

Line 2620: from pay_pss_transaction_steps ppts

2616: cursor csr_ppms(p_transaction_id in number) is
2617: select ppts.transaction_step_id
2618: , ppts.logical_priority
2619: , ppts.amount_type
2620: from pay_pss_transaction_steps ppts
2621: where ppts.transaction_id = p_transaction_id
2622: and pay_ppmv4_ss.include_in_page(C_SUMMARY_PAGE, ppts.state) = 'Y';
2623:
2624: --

Line 3237: from pay_pss_transaction_steps p

3233: , p.transaction_id
3234: into l_state
3235: , l_amount_type
3236: , l_transaction_id
3237: from pay_pss_transaction_steps p
3238: where p.transaction_step_id = p_transaction_step_id;
3239: --
3240: -- If this is a newly created PPM then it's only necessary to update
3241: -- the state.

Line 3245: update pay_pss_transaction_steps p

3241: -- the state.
3242: --
3243: if l_state = C_STATE_NEW then
3244: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'PPM_FREED', 10);
3245: update pay_pss_transaction_steps p
3246: set p.state = C_STATE_FREED
3247: where p.transaction_step_id = p_transaction_step_id;
3248: else
3249: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'TT2PPM', 20);