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_PG_NOTIF_UTILITY_PVT dependencies on PV_GE_PARTY_NOTIF_PVT

Line 8: -- pv_ge_party_notif_pvt, all the references are changed

4: /*----------------------------------------------------------------------------
5: -- HISTORY
6: -- 20-SEP-2002 rdsharma Created
7: -- 11-NOV-2002 SVEERAVE Since the package pv_pgp_notif_pvt is changed to
8: -- pv_ge_party_notif_pvt, all the references are changed
9: -- accordingly. Since pv_ge_party_notifications table
10: -- is change to have partner_id column instead of partner_party_id
11: -- set_pgp_notif procedure is changed to capture partner_id
12: -- all call-outs to set_pgp_notif is changed to pass partner_id

Line 809: x_pgp_notif_rec OUT NOCOPY PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type )

805: p_arc_notif_for_entity_code IN VARCHAR2,
806: p_notif_for_entity_id IN NUMBER,
807: p_notif_type_code IN VARCHAR2,
808: x_return_status OUT NOCOPY VARCHAR2 ,
809: x_pgp_notif_rec OUT NOCOPY PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type )
810: IS
811: BEGIN
812: -- Initialize API return status to success
813: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 980: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;

976: l_vendor_party_id NUMBER;
977: l_vendor_name VARCHAR2(360);
978: l_partner_party_id NUMBER;
979: l_partner_comp_name VARCHAR2(360);
980: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;
981: l_arc_notif_for_entity_code VARCHAR2(30) := 'ENRQ';
982: l_notif_type_code VARCHAR2(30) := 'PG_THANKYOU';
983:
984: /* Declaration of local variables for all the message attributes */

Line 1279: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (

1275: END IF;
1276: END IF;
1277:
1278: /* Call the Create_Ge_Party_Notif to insert a record in PV_GE_PARTY_NOTIFICATION */
1279: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (
1280: p_api_version_number => 1.0,
1281: p_init_msg_list => FND_API.G_FALSE ,
1282: p_commit => FND_API.G_FALSE ,
1283: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

Line 1447: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;

1443: l_vendor_name VARCHAR2(360);
1444: l_vendor_party_id NUMBER;
1445: l_partner_party_id NUMBER;
1446: l_partner_comp_name VARCHAR2(360);
1447: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;
1448: l_arc_notif_for_entity_code VARCHAR2(30) := 'ENRQ';
1449: l_notif_type_code VARCHAR2(30) := 'PG_WELCOME';
1450: l_message_hdr VARCHAR2(2000):= NULL;
1451: l_message_body VARCHAR2(4000):= NULL;

Line 1778: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (

1774: END IF;
1775:
1776: /* Call the Create_Ge_Party_Notif to insert a record in PV_GE_PARTY_NOTIFICATION */
1777:
1778: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (
1779: p_api_version_number => 1.0,
1780: p_init_msg_list => FND_API.G_FALSE ,
1781: p_commit => FND_API.G_FALSE ,
1782: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

Line 1945: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;

1941: l_vendor_party_id NUMBER;
1942: l_partner_party_id NUMBER;
1943: l_vendor_name VARCHAR2(360);
1944: l_partner_comp_name VARCHAR2(360);
1945: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;
1946: l_arc_notif_for_entity_code VARCHAR2(30) := 'ENRQ';
1947: l_notif_type_code VARCHAR2(30) := 'PG_REJECT';
1948:
1949: /* Declaration of local variables for all the message attributes */

Line 2260: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (

2256: END IF;
2257:
2258: /* Call the Create_Ge_Party_Notif to insert a record in PV_GE_PARTY_NOTIFICATION */
2259:
2260: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (
2261: p_api_version_number => 1.0,
2262: p_init_msg_list => FND_API.G_FALSE ,
2263: p_commit => FND_API.G_FALSE ,
2264: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

Line 2427: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;

2423: l_vendor_party_id NUMBER;
2424: l_partner_party_id NUMBER;
2425: l_vendor_name VARCHAR2(360);
2426: l_partner_comp_name VARCHAR2(360);
2427: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;
2428: l_arc_notif_for_entity_code VARCHAR2(30) := 'ENRQ';
2429: l_notif_type_code VARCHAR2(30) := 'PG_CONTRCT_NRCVD';
2430: l_message_hdr VARCHAR2(2000):= NULL;
2431: l_message_body VARCHAR2(4000):= NULL;

Line 2721: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (

2717: END IF;
2718:
2719: /* Call the Create_Ge_Party_Notif to insert a record in PV_GE_PARTY_NOTIFICATION */
2720:
2721: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (
2722: p_api_version_number => 1.0,
2723: p_init_msg_list => FND_API.G_FALSE ,
2724: p_commit => FND_API.G_FALSE ,
2725: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

Line 2891: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;

2887: l_vendor_party_id NUMBER;
2888: l_partner_party_id NUMBER;
2889: l_partner_comp_name VARCHAR2(360);
2890: l_enrl_expiry_in_days VARCHAR2(80);
2891: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;
2892: l_arc_notif_for_entity_code VARCHAR2(30) := 'MEMBR';
2893: l_notif_type_code VARCHAR2(30) := 'PG_MEM_EXP';
2894:
2895: /* Declaration of local variables for all the message attributes */

Line 3234: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (

3230: END IF;
3231:
3232: /* Call the Create_Ge_Party_Notif to insert a record in PV_GE_PARTY_NOTIFICATION */
3233:
3234: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (
3235: p_api_version_number => 1.0,
3236: p_init_msg_list => FND_API.G_FALSE ,
3237: p_commit => FND_API.G_FALSE ,
3238: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

Line 3414: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;

3410: l_user_resource_id NUMBER ;
3411: x_user_notify_rec_tbl user_notify_rec_tbl_type;
3412: l_notif_id NUMBER;
3413: x_party_notification_id NUMBER;
3414: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;
3415: l_arc_notif_for_entity_code VARCHAR2(30) := 'ENRQ';
3416: l_notif_type_code VARCHAR2(30) ;
3417: l_history_category_code VARCHAR2(30) ;
3418: l_log_params_tbl PVX_UTILITY_PVT.log_params_tbl_type;

Line 3598: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (

3594: END IF;
3595:
3596:
3597: /* Call the Create_Ge_Party_Notif to insert a record in PV_GE_PARTY_NOTIFICATION */
3598: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (
3599: p_api_version_number => 1.0,
3600: p_init_msg_list => FND_API.G_FALSE ,
3601: p_commit => FND_API.G_FALSE ,
3602: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

Line 4693: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;

4689: l_approver_id NUMBER;
4690: l_flag VARCHAR2(1);
4691: l_event_code VARCHAR2(30);
4692: l_notification_id NUMBER;
4693: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;
4694: x_party_notifid NUMBER;
4695: l_partner_id NUMBER;
4696: l_entity_id NUMBER;
4697: l_entity_code VARCHAR2(30);

Line 4780: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (

4776: END IF;
4777:
4778:
4779: /* Call the Create_Ge_Party_Notif to insert a record in PV_GE_PARTY_NOTIFICATIONS */
4780: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (
4781: p_api_version_number => 1.0,
4782: p_init_msg_list => FND_API.G_FALSE ,
4783: p_commit => FND_API.G_FALSE ,
4784: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,