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.PV_PRGM_PMT_MODE_PVT dependencies on PV_PROGRAM_PAYMENT_MODE

Line 51: PV_PROGRAM_PAYMENT_MODE pay_mode

47: -- corrected the queries, logic for bug fix#2830585. -- sveerave,03/03/03
48: CURSOR c_get_oe_prgm_pmt_mode(cv_program_payment_mode VARCHAR2, cv_program_id NUMBER, cv_program_geo_hierarchy_id NUMBER) IS
49: SELECT lkp.MEANING
50: FROM oe_lookups lkp,
51: PV_PROGRAM_PAYMENT_MODE pay_mode
52: WHERE lkp.LOOKUP_CODE = cv_program_payment_mode
53: AND pay_mode.PROGRAM_ID = cv_program_id
54: AND pay_mode.GEO_HIERARCHY_ID = cv_program_geo_hierarchy_id
55: AND lkp.lookup_type = 'PAYMENT TYPE';

Line 60: PV_PROGRAM_PAYMENT_MODE pay_mode

56:
57: CURSOR c_get_pv_prgm_pmt_mode(cv_program_payment_mode VARCHAR2, cv_program_id NUMBER, cv_program_geo_hierarchy_id NUMBER) IS
58: SELECT lkp.MEANING
59: FROM pv_lookups lkp,
60: PV_PROGRAM_PAYMENT_MODE pay_mode
61: WHERE lkp.LOOKUP_CODE = cv_program_payment_mode
62: AND pay_mode.PROGRAM_ID = cv_program_id
63: AND pay_mode.GEO_HIERARCHY_ID = cv_program_geo_hierarchy_id
64: AND lkp.lookup_type = 'PV_PAYMENT_TYPE';

Line 115: FROM PV_PROGRAM_PAYMENT_MODE PPPMNT,

111: LH.COUNTRY_NAME, 'CREGION',LH.COUNTRY_REGION_NAME, 'STATE', LH.STATE_NAME, 'SREGION',
112: LH.STATE_REGION_NAME, 'CITY', LH.CITY_NAME,'POSTAL_CODE',
113: LH.POSTAL_CODE_START||'-'||LH.POSTAL_CODE_END) GEO_AREA_NAME,
114: LH.LOCATION_TYPE_NAME LOCATION_TYPE_NAME
115: FROM PV_PROGRAM_PAYMENT_MODE PPPMNT,
116: JTF_LOC_HIERARCHIES_VL LH
117: WHERE PPPMNT.PROGRAM_ID = cv_program_id
118: AND PPPMNT.GEO_HIERARCHY_ID = cv_program_geo_hierarchy_id
119: AND PPPMNT.MODE_OF_PAYMENT = cv_program_payment_mode

Line 187: -- Cursor to get the sequence for pv_program_payment_mode_id

183: l_object_version_number NUMBER := 1;
184: l_uniqueness_check VARCHAR2(1);
185: l_create BOOLEAN;
186:
187: -- Cursor to get the sequence for pv_program_payment_mode_id
188: CURSOR c_prgm_pmt_mode_id_seq IS
189: SELECT PV_PROGRAM_PAYMENT_MODE_S.NEXTVAL
190: FROM dual;
191:

Line 189: SELECT PV_PROGRAM_PAYMENT_MODE_S.NEXTVAL

185: l_create BOOLEAN;
186:
187: -- Cursor to get the sequence for pv_program_payment_mode_id
188: CURSOR c_prgm_pmt_mode_id_seq IS
189: SELECT PV_PROGRAM_PAYMENT_MODE_S.NEXTVAL
190: FROM dual;
191:
192:
193: -- Cursor to validate the uniqueness

Line 196: FROM PV_PROGRAM_PAYMENT_MODE

192:
193: -- Cursor to validate the uniqueness
194: CURSOR c_prgm_pmt_mode_id_seq_exists (l_id IN NUMBER) IS
195: SELECT 'X'
196: FROM PV_PROGRAM_PAYMENT_MODE
197: WHERE program_payment_mode_id = l_id;
198:
199:
200: CURSOR c_prgm_pmt_mode_id (l_id IN NUMBER) IS

Line 202: from PV_PROGRAM_PAYMENT_MODE

198:
199:
200: CURSOR c_prgm_pmt_mode_id (l_id IN NUMBER) IS
201: select PROGRAM_PAYMENT_MODE_ID, object_version_number, MODE_OF_PAYMENT
202: from PV_PROGRAM_PAYMENT_MODE
203: where GEO_HIERARCHY_ID = l_id
204: AND MODE_OF_PAYMENT in ('PO_NUM_DISABLED', 'PO_NUM_ENABLED');
205:
206: BEGIN

Line 453: FROM PV_PROGRAM_PAYMENT_MODE

449: IS
450:
451: CURSOR c_get_prgm_pmt_mode(cv_program_payment_mode_id NUMBER) IS
452: SELECT *
453: FROM PV_PROGRAM_PAYMENT_MODE
454: WHERE PROGRAM_PAYMENT_MODE_ID = cv_program_payment_mode_id;
455:
456: l_api_name CONSTANT VARCHAR2(30) := 'Update_Prgm_Pmt_Mode';
457: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 468: from PV_PROGRAM_PAYMENT_MODE

464: l_update BOOLEAN := true;
465:
466: CURSOR c_prgm_pmt_mode_id (l_id IN NUMBER) IS
467: select GEO_HIERARCHY_ID, MODE_OF_PAYMENT
468: from PV_PROGRAM_PAYMENT_MODE
469: where PROGRAM_PAYMENT_MODE_ID = l_id
470: and MODE_OF_PAYMENT in ('PO_NUM_DISABLED', 'PO_NUM_ENABLED');
471:
472: CURSOR c_prgm_duplicate_pmt_mode (l_id IN NUMBER) IS

Line 474: from PV_PROGRAM_PAYMENT_MODE

470: and MODE_OF_PAYMENT in ('PO_NUM_DISABLED', 'PO_NUM_ENABLED');
471:
472: CURSOR c_prgm_duplicate_pmt_mode (l_id IN NUMBER) IS
473: select GEO_HIERARCHY_ID, MODE_OF_PAYMENT, PROGRAM_PAYMENT_MODE_ID, object_version_number
474: from PV_PROGRAM_PAYMENT_MODE
475: where GEO_HIERARCHY_ID = l_id
476: and MODE_OF_PAYMENT in ('PO_NUM_DISABLED', 'PO_NUM_ENABLED');
477:
478: BEGIN

Line 833: FROM PV_PROGRAM_PAYMENT_MODE

829: l_program_payment_mode_id NUMBER;
830:
831: CURSOR c_prgm_pmt_mode IS
832: SELECT program_payment_mode_id
833: FROM PV_PROGRAM_PAYMENT_MODE
834: WHERE program_payment_mode_id = p_program_payment_mode_id
835: AND object_version_number = p_object_version
836: FOR UPDATE NOWAIT;
837:

Line 986: 'PV_PROGRAM_PAYMENT_MODE',

982: x_return_status := FND_API.g_ret_sts_success;
983: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
984:
985: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
986: 'PV_PROGRAM_PAYMENT_MODE',
987: 'program_payment_mode_id = ''' || p_prgm_pmt_mode_rec.program_payment_mode_id ||''''
988: );
989:
990: IF l_valid_flag = FND_API.g_false THEN

Line 1008: 'PV_PROGRAM_PAYMENT_MODE',

1004: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API' );
1005: END IF;
1006:
1007: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
1008: 'PV_PROGRAM_PAYMENT_MODE',
1009: 'mode_type = '''||
1010: p_prgm_pmt_mode_rec.mode_type ||
1011: ''' and mode_of_payment = '''||
1012: p_prgm_pmt_mode_rec.mode_of_payment||

Line 1449: FROM PV_PROGRAM_PAYMENT_MODE

1445: IS
1446:
1447: CURSOR c_complete IS
1448: SELECT *
1449: FROM PV_PROGRAM_PAYMENT_MODE
1450: WHERE program_payment_mode_id = p_prgm_pmt_mode_rec.program_payment_mode_id;
1451:
1452: l_prgm_pmt_mode_rec c_complete%ROWTYPE;
1453: