DBA Data[Home] [Help]

APPS.PV_TERR_ASSIGN_PUB dependencies on FND_GLOBAL

Line 2683: l_login_user_id := FND_GLOBAL.user_id;

2679:
2680: IF (p_mode <> 'UPDATE') THEN
2681: IF (p_vad_partner_id IS NULL OR p_vad_partner_id = FND_API.g_miss_num) THEN
2682: IF (p_login_user IS NULL OR p_login_user = FND_API.g_miss_num) THEN
2683: l_login_user_id := FND_GLOBAL.user_id;
2684: ELSE
2685: l_login_user_id := p_login_user;
2686: END IF;
2687:

Line 2989: l_login_user NUMBER := FND_GLOBAL.user_id;

2985: l_tap_assign_online VARCHAR2(1);
2986: l_changed_partner_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
2987: l_partner_access_id_tbl prtnr_aces_tbl_type ;
2988: l_partner_exist VARCHAR2(1):= 'N';
2989: l_login_user NUMBER := FND_GLOBAL.user_id;
2990: l_mode VARCHAR2(10);
2991: l_processed_flag VARCHAR2(1) := 'P';
2992: l_object_version_number NUMBER ;
2993:

Line 3357: l_login_user NUMBER := FND_GLOBAL.user_id;

3353: l_prtnr_access_id_tbl prtnr_aces_tbl_type;
3354: l_tap_assign_online VARCHAR2(1);
3355: l_changed_partner_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
3356: l_partner_exist VARCHAR2(1):= 'N';
3357: l_login_user NUMBER := FND_GLOBAL.user_id;
3358: l_mode VARCHAR2(10);
3359: l_processed_flag VARCHAR2(1) := 'P';
3360: l_object_version_number NUMBER ;
3361:

Line 3635: l_login_user_id := FND_GLOBAL.user_id;

3631:
3632: IF (p_mode <> 'UPDATE') THEN
3633: IF (p_vad_partner_id IS NULL OR p_vad_partner_id = FND_API.g_miss_num) THEN
3634: IF (p_login_user IS NULL OR p_login_user = FND_API.g_miss_num) THEN
3635: l_login_user_id := FND_GLOBAL.user_id;
3636: ELSE
3637: l_login_user_id := p_login_user;
3638: END IF;
3639:

Line 4195: l_login_user_id := FND_GLOBAL.user_id;

4191:
4192: IF (p_mode <> 'UPDATE') THEN
4193: IF (p_vad_partner_id IS NULL OR p_vad_partner_id = FND_API.g_miss_num) THEN
4194: IF (p_login_user IS NULL OR p_login_user = FND_API.g_miss_num) THEN
4195: l_login_user_id := FND_GLOBAL.user_id;
4196: ELSE
4197: l_login_user_id := p_login_user;
4198: END IF;
4199:

Line 5406: l_newline VARCHAR2(1) := FND_GLOBAL.Newline;

5402: l_program_id NUMBER := fnd_profile.value('CONC_PROGRAM_ID');
5403: l_program_update_date DATE := sysdate;
5404: l_change_partner PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_rec_type;
5405: rec_index NUMBER := 0;
5406: l_newline VARCHAR2(1) := FND_GLOBAL.Newline;
5407: l_batch_partner_id NUMBER;
5408: l_batch_oversion_number NUMBER;
5409: l_mode VARCHAR2(15) := p_mode;
5410: l_first_partner_id NUMBER := p_first_partner_id;

Line 5632: l_change_partner.last_update_by := FND_GLOBAL.user_id;

5628: l_change_partner.program_id := l_program_id ;
5629: l_change_partner.program_update_date := l_program_update_date;
5630: l_change_partner.object_version_number := l_object_version_number;
5631: l_change_partner.last_update_date := sysdate;
5632: l_change_partner.last_update_by := FND_GLOBAL.user_id;
5633: l_change_partner.creation_date := sysdate;
5634: l_change_partner.created_by := FND_GLOBAL.user_id;
5635: l_change_partner.last_update_login := FND_GLOBAL.user_id;
5636:

Line 5634: l_change_partner.created_by := FND_GLOBAL.user_id;

5630: l_change_partner.object_version_number := l_object_version_number;
5631: l_change_partner.last_update_date := sysdate;
5632: l_change_partner.last_update_by := FND_GLOBAL.user_id;
5633: l_change_partner.creation_date := sysdate;
5634: l_change_partner.created_by := FND_GLOBAL.user_id;
5635: l_change_partner.last_update_login := FND_GLOBAL.user_id;
5636:
5637: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
5638: l_change_partner.processed_flag := 'S';

Line 5635: l_change_partner.last_update_login := FND_GLOBAL.user_id;

5631: l_change_partner.last_update_date := sysdate;
5632: l_change_partner.last_update_by := FND_GLOBAL.user_id;
5633: l_change_partner.creation_date := sysdate;
5634: l_change_partner.created_by := FND_GLOBAL.user_id;
5635: l_change_partner.last_update_login := FND_GLOBAL.user_id;
5636:
5637: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
5638: l_change_partner.processed_flag := 'S';
5639: END IF;

Line 6137: l_login_user_id NUMBER := FND_GLOBAL.user_id;

6133: -- Local variables declaration
6134: l_partner_id NUMBER;
6135: lv_partner_id NUMBER;
6136: l_vad_partner_id NUMBER ;
6137: l_login_user_id NUMBER := FND_GLOBAL.user_id;
6138: l_status BOOLEAN;
6139: l_return_status VARCHAR2(1);
6140: l_msg_count NUMBER;
6141: l_msg_data VARCHAR2(2000);

Line 6150: l_newline VARCHAR2(1) := FND_GLOBAL.Newline;

6146: l_program_id NUMBER := fnd_profile.value('CONC_PROGRAM_ID');
6147: l_program_update_date DATE := sysdate;
6148: l_change_partner PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_rec_type;
6149: rec_index NUMBER := 0;
6150: l_newline VARCHAR2(1) := FND_GLOBAL.Newline;
6151: l_batch_partner_id NUMBER;
6152: l_batch_oversion_number NUMBER;
6153: l_return_terr_str VARCHAR2(2000);
6154: l_partner_rec_exists VARCHAR2(1) := 'N';

Line 6354: l_change_partner.last_update_by := FND_GLOBAL.user_id;

6350: l_change_partner.program_id := l_program_id ;
6351: l_change_partner.program_update_date := l_program_update_date;
6352: l_change_partner.object_version_number := l_object_version_number;
6353: l_change_partner.last_update_date := sysdate;
6354: l_change_partner.last_update_by := FND_GLOBAL.user_id;
6355: l_change_partner.creation_date := sysdate;
6356: l_change_partner.created_by := FND_GLOBAL.user_id;
6357: l_change_partner.last_update_login := FND_GLOBAL.user_id;
6358:

Line 6356: l_change_partner.created_by := FND_GLOBAL.user_id;

6352: l_change_partner.object_version_number := l_object_version_number;
6353: l_change_partner.last_update_date := sysdate;
6354: l_change_partner.last_update_by := FND_GLOBAL.user_id;
6355: l_change_partner.creation_date := sysdate;
6356: l_change_partner.created_by := FND_GLOBAL.user_id;
6357: l_change_partner.last_update_login := FND_GLOBAL.user_id;
6358:
6359: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
6360: l_change_partner.processed_flag := 'S';

Line 6357: l_change_partner.last_update_login := FND_GLOBAL.user_id;

6353: l_change_partner.last_update_date := sysdate;
6354: l_change_partner.last_update_by := FND_GLOBAL.user_id;
6355: l_change_partner.creation_date := sysdate;
6356: l_change_partner.created_by := FND_GLOBAL.user_id;
6357: l_change_partner.last_update_login := FND_GLOBAL.user_id;
6358:
6359: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
6360: l_change_partner.processed_flag := 'S';
6361: END IF;