APPS.PNT_PAYMENT_SCHEDULES_PKG dependencies on PNP_UTIL_FUNC

Line 365: -- 01-DEC-05 pikhar o passed org_id in pnp_util_func.check_conversion_type

361: -- with currency_code <> functional currency. Added cursor
362: -- chk_item_exists. Fix for bug#'s 2707128 and 2714333.
363: -- 21-JUN-05 piagrawa o Bug 4284035 - Replaced pn_payment_items
364: -- with _ALL table.
365: -- 01-DEC-05 pikhar o passed org_id in pnp_util_func.check_conversion_type
366: =============================================================================*/
367:
368: PROCEDURE check_payment_items_acct_amt (
369: p_payment_schedule_id IN NUMBER,

Line 407: l_type := pnp_util_func.check_conversion_type(p_functional_currency,l_org_id );

403: FOR rec IN org_cur LOOP
404: l_org_id := rec.org_id;
405: END LOOP;
406:
407: l_type := pnp_util_func.check_conversion_type(p_functional_currency,l_org_id );
408: p_error_flag := 'N';
409:
410: IF l_type IS NULL THEN
411:

Line 439: l_dummy := pnp_util_func.export_curr_amount(

435: p_error_flag := 'Y';
436: EXIT;
437: ELSIF UPPER(l_type) <> 'USER' THEN
438:
439: l_dummy := pnp_util_func.export_curr_amount(
440: currency_code => payment_record.currency_code,
441: export_currency_code => p_functional_currency,
442: export_date => l_date,
443: conversion_type => l_type,

Line 956: -- 01-DEC-05 pikhar o passed org_id in pnp_util_func.check_conversion_type

952: -- 07-OCT-02 Ashish o BUG#2590872 update the normalized items
953: -- along with the cash items.
954: -- 21-JUN-05 piagrawa o Bug 4284035 - Replaced pn_payment_items
955: -- with _ALL table.
956: -- 01-DEC-05 pikhar o passed org_id in pnp_util_func.check_conversion_type
957: -------------------------------------------------------------------------------
958:
959: PROCEDURE update_accounted_amount (
960: p_pnt_sched_id IN NUMBER,

Line 1018: l_type := pnp_util_func.check_conversion_type(p_lease_functional_currency,l_org_id);

1014: FOR rec IN org_cur LOOP
1015: l_org_id := rec.org_id;
1016: END LOOP;
1017:
1018: l_type := pnp_util_func.check_conversion_type(p_lease_functional_currency,l_org_id);
1019:
1020: FOR payment_item_rec IN payment_cursor LOOP
1021:
1022: /*---------ADDED FOR BUG#2590872---------*/

Line 1044: l_temp := pnp_util_func.export_curr_amount(

1040: l_temp := NVL(payment_item_rec.actual_amount,0) * NVL(payment_item_rec.rate,0);
1041: l_temp1 := NVL(V_actual_amount,0) * NVL(PAYMENT_item_rec.rate,0); --ADDED FOR BUG#2590872
1042:
1043: ELSE
1044: l_temp := pnp_util_func.export_curr_amount(
1045: currency_code => payment_item_rec.currency_code,
1046: export_currency_code => p_lease_functional_currency,
1047: export_date => l_date,
1048: conversion_type => l_type,

Line 1053: l_temp1 := pnp_util_func.export_curr_amount(

1049: actual_amount => NVL(payment_item_rec.actual_amount,0),
1050: p_called_from => 'NOTPNTAUPMT'
1051: );
1052: --ADDED FOR BUG#2590872
1053: l_temp1 := pnp_util_func.export_curr_amount(
1054: currency_code => payment_item_rec.currency_code,
1055: export_currency_code => p_lease_functional_currency,
1056: export_date => l_date,
1057: conversion_type => l_type,

Line 1112: -- 01-DEC-05 pikhar o passed org_id in pnp_util_func.check_conversion_type

1108: -- HISTORY :
1109: -- 07-JAN-03 psidhu o Created
1110: -- 21-JUN-05 piagrawa o Bug 4284035 - Replaced pn_payment_items
1111: -- with _ALL table.
1112: -- 01-DEC-05 pikhar o passed org_id in pnp_util_func.check_conversion_type
1113: -------------------------------------------------------------------------------
1114: PROCEDURE update_rate (
1115: p_pnt_sched_id IN NUMBER,
1116: p_payment_status_lookup_code IN VARCHAR2,

Line 1146: l_type := pnp_util_func.check_conversion_type(p_lease_functional_currency,l_org_id);

1142: FOR rec IN org_cur LOOP
1143: l_org_id := rec.org_id;
1144: END LOOP;
1145:
1146: l_type := pnp_util_func.check_conversion_type(p_lease_functional_currency,l_org_id);
1147:
1148: FOR payment_item_rec IN payment_cursor LOOP
1149:
1150: IF payment_item_rec.due_date > SYSDATE THEN