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_USER_RESP_PVT dependencies on PV_GE_PTNR_RESPS_PVT

Line 1751: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

1747: l_api_name CONSTANT VARCHAR2(30) := 'get_default_assign_addrow';
1748: l_exist NUMBER;
1749: l_responsibility_id NUMBER;
1750: l_resp_map_rule_id NUMBER;
1751: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
1752: l_ptnr_resp_id NUMBER;
1753: l_user_ids_tbl JTF_NUMBER_TABLE;
1754:
1755: BEGIN

Line 1835: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

1831: Debug_Log('get_default_assign_addrow: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
1832: Debug_Log('get_default_assign_addrow: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
1833: END IF;
1834:
1835: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
1836: p_api_version_number => p_api_version_number
1837: ,p_init_msg_list => FND_API.G_FALSE
1838: ,p_commit => FND_API.G_FALSE
1839: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1927: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

1923: IS
1924: l_api_name CONSTANT VARCHAR2(30) := 'assign_first_user_resp';
1925: l_api_version_number CONSTANT NUMBER := 1.0;
1926: l_ptnr_resp_id NUMBER;
1927: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
1928:
1929: BEGIN
1930: ---- Initialize----------------
1931:

Line 1996: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

1992: Debug_Log('assign_first_user_resp: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
1993: Debug_Log('assign_first_user_resp: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
1994: END IF;
1995:
1996: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
1997: p_api_version_number => p_api_version_number
1998: ,p_init_msg_list => FND_API.G_FALSE
1999: ,p_commit => FND_API.G_FALSE
2000: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2105: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

2101: l_responsibility_id NUMBER;
2102: l_resp_map_rule_id NUMBER;
2103: l_partner_ids_tbl JTF_NUMBER_TABLE;
2104: l_resp_exist VARCHAR(1) := 'N';
2105: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
2106: l_ptnr_resp_id NUMBER;
2107: l_user_ids_tbl JTF_NUMBER_TABLE;
2108: BEGIN
2109: ---- Initialize----------------

Line 2233: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

2229: Debug_Log('assign_user_resps: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
2230: Debug_Log('assign_user_resps: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
2231: END IF;
2232:
2233: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
2234: p_api_version_number => p_api_version_number
2235: ,p_init_msg_list => FND_API.G_FALSE
2236: ,p_commit => FND_API.G_FALSE
2237: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2750: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

2746: l_api_name CONSTANT VARCHAR2(30) := 'revoke_update_assign';
2747: l_exist NUMBER;
2748: l_responsibility_id NUMBER;
2749: l_resp_map_rule_id NUMBER;
2750: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
2751: l_ptnr_resp_id NUMBER;
2752:
2753: BEGIN
2754: ---- Initialize----------------

Line 2810: PV_Ge_Ptnr_Resps_PVT.Update_Ge_Ptnr_Resps(

2806: Debug_Log('revoke_update_assign: l_ge_ptnr_resps_rec.responsibility_id = ' || l_ge_ptnr_resps_rec.responsibility_id);
2807: Debug_Log('revoke_update_assign: l_ge_ptnr_resps_rec.object_version_number = ' || l_ge_ptnr_resps_rec.object_version_number);
2808: END IF;
2809:
2810: PV_Ge_Ptnr_Resps_PVT.Update_Ge_Ptnr_Resps(
2811: p_api_version_number => p_api_version_number
2812: ,p_init_msg_list => FND_API.G_FALSE
2813: ,p_commit => FND_API.G_FALSE
2814: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3044: Debug_Log('manage_ter_exp_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');

3040: /****
3041: * API to delete the row with ptnr_resp_id = x.ptnr_resp_id from pv_partner_memberships
3042: ****/
3043: IF (PV_DEBUG_HIGH_ON) THEN
3044: Debug_Log('manage_ter_exp_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
3045: Debug_Log('manage_ter_exp_memb_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
3046: END IF;
3047:
3048: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

Line 3048: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

3044: Debug_Log('manage_ter_exp_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
3045: Debug_Log('manage_ter_exp_memb_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
3046: END IF;
3047:
3048: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(
3049: p_api_version_number => p_api_version_number
3050: ,p_init_msg_list => FND_API.G_FALSE
3051: ,p_commit => FND_API.G_FALSE
3052: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3095: Debug_Log('manage_ter_exp_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');

3091: /****
3092: * API to delete the row with ptnr_resp_id = x.ptnr_resp_id from pv_partner_memberships
3093: ****/
3094: IF (PV_DEBUG_HIGH_ON) THEN
3095: Debug_Log('manage_ter_exp_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
3096: Debug_Log('manage_ter_exp_memb_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
3097: END IF;
3098:
3099: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

Line 3099: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

3095: Debug_Log('manage_ter_exp_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
3096: Debug_Log('manage_ter_exp_memb_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
3097: END IF;
3098:
3099: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(
3100: p_api_version_number => p_api_version_number
3101: ,p_init_msg_list => FND_API.G_FALSE
3102: ,p_commit => p_commit
3103: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3169: Debug_Log('manage_ter_exp_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');

3165: /****
3166: * API to delete the row with ptnr_resp_id = x.ptnr_resp_id from pv_partner_memberships
3167: ****/
3168: IF (PV_DEBUG_HIGH_ON) THEN
3169: Debug_Log('manage_ter_exp_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
3170: Debug_Log('manage_ter_exp_memb_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
3171: END IF;
3172:
3173: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

Line 3173: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

3169: Debug_Log('manage_ter_exp_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
3170: Debug_Log('manage_ter_exp_memb_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
3171: END IF;
3172:
3173: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(
3174: p_api_version_number => p_api_version_number
3175: ,p_init_msg_list => FND_API.G_FALSE
3176: ,p_commit => FND_API.G_FALSE
3177: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3282: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

3278: l_store_responsibility_id JTF_NUMBER_TABLE;
3279: l_store_resp_map_rule_id JTF_NUMBER_TABLE;
3280: l_resp_map_rule_id NUMBER;
3281: l_ptnr_resp_id NUMBER;
3282: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
3283: l_user_ids_tbl JTF_NUMBER_TABLE;
3284:
3285: BEGIN
3286: ---- Initialize----------------

Line 3377: Debug_Log('manage_active_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');

3373: /****
3374: * API to delete the row with ptnr_resp_id = x.ptnr_resp_id from pv_partner_memberships
3375: ****/
3376: IF (PV_DEBUG_HIGH_ON) THEN
3377: Debug_Log('manage_active_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
3378: Debug_Log('manage_active_memb_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
3379: END IF;
3380:
3381: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

Line 3381: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

3377: Debug_Log('manage_active_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
3378: Debug_Log('manage_active_memb_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
3379: END IF;
3380:
3381: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(
3382: p_api_version_number => p_api_version_number
3383: ,p_init_msg_list => FND_API.G_FALSE
3384: ,p_commit => FND_API.G_FALSE
3385: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3422: Debug_Log('manage_active_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps');

3418: /****
3419: * API to add a row to pv_ge_ptnr_resps
3420: ****/
3421: IF (PV_DEBUG_HIGH_ON) THEN
3422: Debug_Log('manage_active_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps');
3423: END IF;
3424:
3425: l_ge_ptnr_resps_rec.partner_id := p_partner_id;
3426: l_ge_ptnr_resps_rec.user_role_code := G_PRIMARY;

Line 3441: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

3437: Debug_Log('manage_active_memb_resp: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
3438: Debug_Log('manage_active_memb_resp: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
3439: END IF;
3440:
3441: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
3442: p_api_version_number => p_api_version_number
3443: ,p_init_msg_list => FND_API.G_FALSE
3444: ,p_commit => FND_API.G_FALSE
3445: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3512: Debug_Log('manage_active_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');

3508: /****
3509: * API to delete the row with ptnr_resp_id = x.ptnr_resp_id from pv_partner_memberships
3510: ****/
3511: IF (PV_DEBUG_HIGH_ON) THEN
3512: Debug_Log('manage_active_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
3513: Debug_Log('manage_active_memb_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
3514: END IF;
3515:
3516: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

Line 3516: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

3512: Debug_Log('manage_active_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
3513: Debug_Log('manage_active_memb_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
3514: END IF;
3515:
3516: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(
3517: p_api_version_number => p_api_version_number
3518: ,p_init_msg_list => FND_API.G_FALSE
3519: ,p_commit => p_commit
3520: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3558: Debug_Log('manage_active_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps');

3554: /****
3555: * API to add a row to pv_ptnr_resps
3556: ****/
3557: IF (PV_DEBUG_HIGH_ON) THEN
3558: Debug_Log('manage_active_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps');
3559: END IF;
3560:
3561: l_ge_ptnr_resps_rec.partner_id := p_partner_id;
3562: l_ge_ptnr_resps_rec.user_role_code := G_BUSINESS;

Line 3577: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

3573: Debug_Log('manage_active_memb_resp: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
3574: Debug_Log('manage_active_memb_resp: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
3575: END IF;
3576:
3577: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
3578: p_api_version_number => p_api_version_number
3579: ,p_init_msg_list => FND_API.G_FALSE
3580: ,p_commit => FND_API.G_FALSE
3581: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3644: Debug_Log('manage_active_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps');

3640: END IF;
3641: END LOOP; -- End of l_user_ids_tbl
3642:
3643: IF (PV_DEBUG_HIGH_ON) THEN
3644: Debug_Log('manage_active_memb_resp: before calling PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps');
3645: END IF;
3646:
3647: /****
3648: * API to add a row to pv_ptnr_resps

Line 3666: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

3662: Debug_Log('manage_active_memb_resp: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
3663: Debug_Log('manage_active_memb_resp: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
3664: END IF;
3665:
3666: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
3667: p_api_version_number => p_api_version_number
3668: ,p_init_msg_list => FND_API.G_FALSE
3669: ,p_commit => FND_API.G_FALSE
3670: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3956: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

3952: l_count NUMBER;
3953: l_responsibility_id NUMBER;
3954: l_resp_map_rule_id NUMBER;
3955: l_ptnr_resp_id NUMBER;
3956: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
3957:
3958: BEGIN
3959: ---- Initialize----------------
3960:

Line 4026: Debug_Log('delete_resp_mapping: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');

4022: /****
4023: * API to delete the row with ptnr_resp_id = x.ptnr_resp_id from pv_partner_memberships
4024: ****/
4025: IF (PV_DEBUG_HIGH_ON) THEN
4026: Debug_Log('delete_resp_mapping: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
4027: Debug_Log('delete_resp_mapping: x.ptnr_resp_id = ' || x.ptnr_resp_id);
4028: END IF;
4029:
4030: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

Line 4030: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

4026: Debug_Log('delete_resp_mapping: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
4027: Debug_Log('delete_resp_mapping: x.ptnr_resp_id = ' || x.ptnr_resp_id);
4028: END IF;
4029:
4030: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(
4031: p_api_version_number => p_api_version_number
4032: ,p_init_msg_list => FND_API.G_FALSE
4033: ,p_commit => FND_API.G_FALSE
4034: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 4123: Debug_Log('delete_resp_mapping: before calling PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps');

4119: /****
4120: * API to add a row to Create_Ge_Ptnr_Resps
4121: ****/
4122: IF (PV_DEBUG_HIGH_ON) THEN
4123: Debug_Log('delete_resp_mapping: before calling PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps');
4124: END IF;
4125: l_ge_ptnr_resps_rec.partner_id := x.partner_id;
4126: l_ge_ptnr_resps_rec.user_role_code := x.user_role_code;
4127: l_ge_ptnr_resps_rec.responsibility_id := l_responsibility_id;

Line 4141: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

4137: Debug_Log('delete_resp_mapping: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
4138: Debug_Log('delete_resp_mapping: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
4139: END IF;
4140:
4141: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
4142: p_api_version_number => p_api_version_number
4143: ,p_init_msg_list => FND_API.G_FALSE
4144: ,p_commit => FND_API.G_FALSE
4145: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 4181: Debug_Log('delete_resp_mapping: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');

4177: /****
4178: * API to delete the row with ptnr_resp_id = x.ptnr_resp_id from pv_partner_memberships
4179: ****/
4180: IF (PV_DEBUG_HIGH_ON) THEN
4181: Debug_Log('delete_resp_mapping: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
4182: Debug_Log('delete_resp_mapping: x.ptnr_resp_id = ' || x.ptnr_resp_id);
4183: END IF;
4184:
4185: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

Line 4185: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

4181: Debug_Log('delete_resp_mapping: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
4182: Debug_Log('delete_resp_mapping: x.ptnr_resp_id = ' || x.ptnr_resp_id);
4183: END IF;
4184:
4185: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(
4186: p_api_version_number => p_api_version_number
4187: ,p_init_msg_list => FND_API.G_FALSE
4188: ,p_commit => p_commit
4189: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 4581: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

4577: l_new_responsibility_id NUMBER;
4578: l_resp_map_rule_id NUMBER;
4579: l_same_comb boolean;
4580: l_exist NUMBER;
4581: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
4582: l_ptnr_resp_id NUMBER;
4583: BEGIN
4584: ---- Initialize----------------
4585:

Line 4738: Debug_Log('create_resp_mapping: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');

4734: /****
4735: * API to delete the row with ptnr_resp_id = x.ptnr_resp_id from pv_partner_memberships
4736: ****/
4737: IF (PV_DEBUG_HIGH_ON) THEN
4738: Debug_Log('create_resp_mapping: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
4739: Debug_Log('create_resp_mapping: y.ptnr_resp_id = ' || y.ptnr_resp_id);
4740: Debug_Log('create_resp_mapping: y.object_version_number = ' || y.object_version_number);
4741: END IF;
4742:

Line 4743: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

4739: Debug_Log('create_resp_mapping: y.ptnr_resp_id = ' || y.ptnr_resp_id);
4740: Debug_Log('create_resp_mapping: y.object_version_number = ' || y.object_version_number);
4741: END IF;
4742:
4743: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(
4744: p_api_version_number => p_api_version_number
4745: ,p_init_msg_list => FND_API.G_FALSE
4746: ,p_commit => FND_API.G_FALSE
4747: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 4796: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

4792: Debug_Log('create_resp_mapping: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
4793: Debug_Log('create_resp_mapping: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
4794: END IF;
4795:
4796: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
4797: p_api_version_number => p_api_version_number
4798: ,p_init_msg_list => FND_API.G_FALSE
4799: ,p_commit => FND_API.G_FALSE
4800: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 5258: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

5254:
5255: l_api_name CONSTANT VARCHAR2(30) := 'manage_store_resp_on_create';
5256: l_api_version_number CONSTANT NUMBER := 1.0;
5257: l_user_ids_tbl JTF_NUMBER_TABLE;
5258: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
5259: l_ptnr_resp_id NUMBER;
5260: l_exist NUMBER;
5261: BEGIN
5262: ---- Initialize----------------

Line 5349: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

5345: Debug_Log('manage_store_resp_on_create: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
5346: Debug_Log('manage_store_resp_on_create: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
5347: END IF;
5348:
5349: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
5350: p_api_version_number => p_api_version_number
5351: ,p_init_msg_list => FND_API.G_FALSE
5352: ,p_commit => FND_API.G_FALSE
5353: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 5477: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

5473: l_api_name CONSTANT VARCHAR2(30) := 'manage_store_resp_on_delete';
5474: l_api_version_number CONSTANT NUMBER := 1.0;
5475: l_count NUMBER;
5476: l_no_revoke BOOLEAN;
5477: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
5478:
5479: BEGIN
5480: ---- Initialize----------------
5481:

Line 5569: Debug_Log('manage_store_resp_on_delete: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');

5565: /****
5566: * API to delete the row with ptnr_resp_id = x.ptnr_resp_id from pv_partner_memberships
5567: ****/
5568: IF (PV_DEBUG_HIGH_ON) THEN
5569: Debug_Log('manage_store_resp_on_delete: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
5570: Debug_Log('manage_store_resp_on_delete: x.ptnr_resp_id = ' || x.ptnr_resp_id);
5571: Debug_Log('manage_store_resp_on_delete: x.object_version_number = ' || x.object_version_number);
5572: END IF;
5573:

Line 5574: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

5570: Debug_Log('manage_store_resp_on_delete: x.ptnr_resp_id = ' || x.ptnr_resp_id);
5571: Debug_Log('manage_store_resp_on_delete: x.object_version_number = ' || x.object_version_number);
5572: END IF;
5573:
5574: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(
5575: p_api_version_number => p_api_version_number
5576: ,p_init_msg_list => FND_API.G_FALSE
5577: ,p_commit => FND_API.G_FALSE
5578: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 5751: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

5747: l_api_version_number CONSTANT NUMBER := 1.0;
5748: l_responsibility_id NUMBER;
5749: l_resp_map_rule_id NUMBER;
5750: l_partner_ids_tbl JTF_NUMBER_TABLE;
5751: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
5752: l_ptnr_resp_id NUMBER;
5753:
5754: BEGIN
5755: ---- Initialize----------------

Line 5842: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

5838: WRITE_LOG(l_api_name, 'assign_default_resp: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
5839: WRITE_LOG(l_api_name, 'assign_default_resp: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
5840: END IF;
5841:
5842: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
5843: p_api_version_number => p_api_version_number
5844: ,p_init_msg_list => FND_API.G_FALSE
5845: ,p_commit => FND_API.G_FALSE
5846: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 5917: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

5913: WRITE_LOG(l_api_name, 'assign_default_resp: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
5914: WRITE_LOG(l_api_name, 'assign_default_resp: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
5915: END IF;
5916:
5917: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
5918: p_api_version_number => p_api_version_number
5919: ,p_init_msg_list => FND_API.G_FALSE
5920: ,p_commit => FND_API.G_FALSE
5921: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 6017: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

6013: primary_user_ids_tbl JTF_NUMBER_TABLE;
6014: business_user_ids_tbl JTF_NUMBER_TABLE;
6015: l_responsibility_id NUMBER;
6016: l_resp_map_rule_id NUMBER;
6017: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
6018: l_ptnr_resp_id NUMBER;
6019: l_exist NUMBER;
6020: BEGIN
6021: ---- Initialize----------------

Line 6116: Debug_Log('manage_resp_on_address_change: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');

6112: /****
6113: * API to delete the row with ptnr_resp_id = x.ptnr_resp_id
6114: ****/
6115: IF (PV_DEBUG_HIGH_ON) THEN
6116: Debug_Log('manage_resp_on_address_change: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
6117: Debug_Log('manage_resp_on_address_change: y.ptnr_resp_id = ' || y.ptnr_resp_id);
6118: Debug_Log('manage_resp_on_address_change: y.object_version_number = ' || y.object_version_number);
6119: END IF;
6120:

Line 6121: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

6117: Debug_Log('manage_resp_on_address_change: y.ptnr_resp_id = ' || y.ptnr_resp_id);
6118: Debug_Log('manage_resp_on_address_change: y.object_version_number = ' || y.object_version_number);
6119: END IF;
6120:
6121: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(
6122: p_api_version_number => p_api_version_number
6123: ,p_init_msg_list => FND_API.G_FALSE
6124: ,p_commit => FND_API.G_FALSE
6125: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 6236: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

6232: Debug_Log('manage_resp_on_address_change: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
6233: Debug_Log('manage_resp_on_address_change: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
6234: END IF;
6235:
6236: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
6237: p_api_version_number => p_api_version_number
6238: ,p_init_msg_list => FND_API.G_FALSE
6239: ,p_commit => FND_API.G_FALSE
6240: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 6476: Debug_Log('revoke_default_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');

6472: /****
6473: * API to delete the row with ptnr_resp_id = x.ptnr_resp_id from pv_partner_memberships
6474: ****/
6475: IF (PV_DEBUG_HIGH_ON) THEN
6476: Debug_Log('revoke_default_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
6477: Debug_Log('revoke_default_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
6478: WRITE_LOG(l_api_name, 'revoke_default_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
6479: WRITE_LOG(l_api_name, 'revoke_default_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
6480: END IF;

Line 6478: WRITE_LOG(l_api_name, 'revoke_default_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');

6474: ****/
6475: IF (PV_DEBUG_HIGH_ON) THEN
6476: Debug_Log('revoke_default_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
6477: Debug_Log('revoke_default_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
6478: WRITE_LOG(l_api_name, 'revoke_default_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
6479: WRITE_LOG(l_api_name, 'revoke_default_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
6480: END IF;
6481:
6482: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

Line 6482: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(

6478: WRITE_LOG(l_api_name, 'revoke_default_resp: before calling PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps');
6479: WRITE_LOG(l_api_name, 'revoke_default_resp: x.ptnr_resp_id = ' || x.ptnr_resp_id);
6480: END IF;
6481:
6482: PV_Ge_Ptnr_Resps_PVT.Delete_Ge_Ptnr_Resps(
6483: p_api_version_number => p_api_version_number
6484: ,p_init_msg_list => FND_API.G_FALSE
6485: ,p_commit => FND_API.G_FALSE
6486: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 7115: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

7111: l_user_ids_tbl JTF_NUMBER_TABLE;
7112: l_resp_exist VARCHAR(1) := 'N';
7113: l_responsibility_id NUMBER;
7114: l_resp_map_rule_id NUMBER;
7115: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
7116: l_ptnr_resp_id NUMBER;
7117:
7118: BEGIN
7119: ---- Initialize----------------

Line 7214: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

7210: Debug_Log('manage_merged_party_memb_resp: l_ge_ptnr_resps_rec.responsibility_id = ' || l_ge_ptnr_resps_rec.responsibility_id);
7211: Debug_Log('manage_merged_party_memb_resp: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
7212: Debug_Log('manage_merged_party_memb_resp: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
7213:
7214: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
7215: p_api_version_number => p_api_version_number
7216: ,p_init_msg_list => FND_API.G_FALSE
7217: ,p_commit => FND_API.G_FALSE
7218: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 7264: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(

7260: Debug_Log('manage_merged_party_memb_resp: l_ge_ptnr_resps_rec.responsibility_id = ' || l_ge_ptnr_resps_rec.responsibility_id);
7261: Debug_Log('manage_merged_party_memb_resp: l_ge_ptnr_resps_rec.source_resp_map_rule_id = ' || l_ge_ptnr_resps_rec.source_resp_map_rule_id);
7262: Debug_Log('manage_merged_party_memb_resp: l_ge_ptnr_resps_rec.resp_type_code = ' || l_ge_ptnr_resps_rec.resp_type_code);
7263:
7264: PV_Ge_Ptnr_Resps_PVT.Create_Ge_Ptnr_Resps(
7265: p_api_version_number => p_api_version_number
7266: ,p_init_msg_list => FND_API.G_FALSE
7267: ,p_commit => FND_API.G_FALSE
7268: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL