DBA Data[Home] [Help]

APPS.PV_PEC_RULES_PVT dependencies on FND_GLOBAL

Line 23: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Pec_Rules_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvecrb.pls';
22:
23: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
25: --
26: -- Foreward Procedure Declarations
27: --

Line 24: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Pec_Rules_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvecrb.pls';
22:
23: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
25: --
26: -- Foreward Procedure Declarations
27: --
28:

Line 263: IF FND_GLOBAL.USER_ID IS NULL

259: -- =========================================================================
260: -- Validate Environment
261: -- =========================================================================
262:
263: IF FND_GLOBAL.USER_ID IS NULL
264: THEN
265: PVX_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;

Line 286: l_pec_rules_rec.last_updated_by := FND_GLOBAL.user_id;

282: PVX_UTILITY_PVT.debug_message('Private API: Validate_Pec_Rules');
283: END IF;
284:
285: l_pec_rules_rec.last_update_date := SYSDATE;
286: l_pec_rules_rec.last_updated_by := FND_GLOBAL.user_id;
287: l_pec_rules_rec.creation_date := SYSDATE;
288: l_pec_rules_rec.created_by := FND_GLOBAL.user_id;
289: l_pec_rules_rec.last_update_login := FND_GLOBAL.conc_login_id;
290: l_pec_rules_rec.object_version_number := l_object_version_number;

Line 288: l_pec_rules_rec.created_by := FND_GLOBAL.user_id;

284:
285: l_pec_rules_rec.last_update_date := SYSDATE;
286: l_pec_rules_rec.last_updated_by := FND_GLOBAL.user_id;
287: l_pec_rules_rec.creation_date := SYSDATE;
288: l_pec_rules_rec.created_by := FND_GLOBAL.user_id;
289: l_pec_rules_rec.last_update_login := FND_GLOBAL.conc_login_id;
290: l_pec_rules_rec.object_version_number := l_object_version_number;
291:
292: l_pec_rules_rec.effective_from_date := SYSDATE;

Line 289: l_pec_rules_rec.last_update_login := FND_GLOBAL.conc_login_id;

285: l_pec_rules_rec.last_update_date := SYSDATE;
286: l_pec_rules_rec.last_updated_by := FND_GLOBAL.user_id;
287: l_pec_rules_rec.creation_date := SYSDATE;
288: l_pec_rules_rec.created_by := FND_GLOBAL.user_id;
289: l_pec_rules_rec.last_update_login := FND_GLOBAL.conc_login_id;
290: l_pec_rules_rec.object_version_number := l_object_version_number;
291:
292: l_pec_rules_rec.effective_from_date := SYSDATE;
293:

Line 340: p_created_by => FND_GLOBAL.USER_ID,

336: p_change_direction_code => l_pec_rules_rec.change_direction_code,
337: p_effective_from_date => l_pec_rules_rec.effective_from_date,
338: p_effective_to_date => l_pec_rules_rec.effective_to_date,
339: p_active_flag => l_pec_rules_rec.active_flag,
340: p_created_by => FND_GLOBAL.USER_ID,
341: p_creation_date => SYSDATE,
342: p_last_updated_by => FND_GLOBAL.USER_ID,
343: p_last_update_date => SYSDATE,
344: p_last_update_login => FND_GLOBAL.conc_login_id

Line 342: p_last_updated_by => FND_GLOBAL.USER_ID,

338: p_effective_to_date => l_pec_rules_rec.effective_to_date,
339: p_active_flag => l_pec_rules_rec.active_flag,
340: p_created_by => FND_GLOBAL.USER_ID,
341: p_creation_date => SYSDATE,
342: p_last_updated_by => FND_GLOBAL.USER_ID,
343: p_last_update_date => SYSDATE,
344: p_last_update_login => FND_GLOBAL.conc_login_id
345: );
346:

Line 344: p_last_update_login => FND_GLOBAL.conc_login_id

340: p_created_by => FND_GLOBAL.USER_ID,
341: p_creation_date => SYSDATE,
342: p_last_updated_by => FND_GLOBAL.USER_ID,
343: p_last_update_date => SYSDATE,
344: p_last_update_login => FND_GLOBAL.conc_login_id
345: );
346:
347: x_enrl_change_rule_id := l_enrl_change_rule_id;
348:

Line 367: p_created_by => FND_GLOBAL.USER_ID,

363: p_change_direction_code => l_change_direction_code,
364: p_effective_from_date => l_pec_rules_rec.effective_from_date,
365: p_effective_to_date => l_pec_rules_rec.effective_to_date,
366: p_active_flag => l_pec_rules_rec.active_flag,
367: p_created_by => FND_GLOBAL.USER_ID,
368: p_creation_date => SYSDATE,
369: p_last_updated_by => FND_GLOBAL.USER_ID,
370: p_last_update_date => SYSDATE,
371: p_last_update_login => FND_GLOBAL.conc_login_id

Line 369: p_last_updated_by => FND_GLOBAL.USER_ID,

365: p_effective_to_date => l_pec_rules_rec.effective_to_date,
366: p_active_flag => l_pec_rules_rec.active_flag,
367: p_created_by => FND_GLOBAL.USER_ID,
368: p_creation_date => SYSDATE,
369: p_last_updated_by => FND_GLOBAL.USER_ID,
370: p_last_update_date => SYSDATE,
371: p_last_update_login => FND_GLOBAL.conc_login_id
372: );
373:

Line 371: p_last_update_login => FND_GLOBAL.conc_login_id

367: p_created_by => FND_GLOBAL.USER_ID,
368: p_creation_date => SYSDATE,
369: p_last_updated_by => FND_GLOBAL.USER_ID,
370: p_last_update_date => SYSDATE,
371: p_last_update_login => FND_GLOBAL.conc_login_id
372: );
373:
374: x_enrl_change_rule_id := l_enrl_change_rule_id;
375: END IF;

Line 642: p_last_updated_by => FND_GLOBAL.USER_ID,

638: p_change_direction_code => p_pec_rules_rec.change_direction_code,
639: p_effective_from_date => p_pec_rules_rec.effective_from_date,
640: p_effective_to_date => p_pec_rules_rec.effective_to_date,
641: p_active_flag => p_pec_rules_rec.active_flag,
642: p_last_updated_by => FND_GLOBAL.USER_ID,
643: p_last_update_date => SYSDATE,
644: p_last_update_login => FND_GLOBAL.conc_login_id );
645:
646: x_object_version_number := l_object_version_number;

Line 644: p_last_update_login => FND_GLOBAL.conc_login_id );

640: p_effective_to_date => p_pec_rules_rec.effective_to_date,
641: p_active_flag => p_pec_rules_rec.active_flag,
642: p_last_updated_by => FND_GLOBAL.USER_ID,
643: p_last_update_date => SYSDATE,
644: p_last_update_login => FND_GLOBAL.conc_login_id );
645:
646: x_object_version_number := l_object_version_number;
647:
648:

Line 664: p_last_updated_by => FND_GLOBAL.USER_ID,

660: p_change_direction_code => downg.change_direction_code,
661: p_effective_from_date => downg.effective_from_date,
662: p_effective_to_date => downg.effective_to_date,
663: p_active_flag => p_pec_rules_rec.active_flag,
664: p_last_updated_by => FND_GLOBAL.USER_ID,
665: p_last_update_date => SYSDATE,
666: p_last_update_login => FND_GLOBAL.conc_login_id);
667:
668: END LOOP;

Line 666: p_last_update_login => FND_GLOBAL.conc_login_id);

662: p_effective_to_date => downg.effective_to_date,
663: p_active_flag => p_pec_rules_rec.active_flag,
664: p_last_updated_by => FND_GLOBAL.USER_ID,
665: p_last_update_date => SYSDATE,
666: p_last_update_login => FND_GLOBAL.conc_login_id);
667:
668: END LOOP;
669: END IF;
670: -- End of API body.

Line 893: p_last_updated_by => FND_GLOBAL.USER_ID,

889: p_change_direction_code => l_ref_pec_rules_rec.change_direction_code,
890: p_effective_from_date => l_ref_pec_rules_rec.effective_from_date,
891: p_effective_to_date => SYSDATE,
892: p_active_flag => l_ref_pec_rules_rec.active_flag,
893: p_last_updated_by => FND_GLOBAL.USER_ID,
894: p_last_update_date => SYSDATE,
895: p_last_update_login => FND_GLOBAL.conc_login_id);
896:
897:

Line 895: p_last_update_login => FND_GLOBAL.conc_login_id);

891: p_effective_to_date => SYSDATE,
892: p_active_flag => l_ref_pec_rules_rec.active_flag,
893: p_last_updated_by => FND_GLOBAL.USER_ID,
894: p_last_update_date => SYSDATE,
895: p_last_update_login => FND_GLOBAL.conc_login_id);
896:
897:
898: -- x_object_version_number => l_object_version_number);
899: --

Line 944: p_last_updated_by => FND_GLOBAL.USER_ID,

940: p_change_direction_code => downg.change_direction_code,
941: p_effective_from_date => downg.effective_from_date,
942: p_effective_to_date => SYSDATE,
943: p_active_flag => downg.active_flag,
944: p_last_updated_by => FND_GLOBAL.USER_ID,
945: p_last_update_date => SYSDATE,
946: p_last_update_login => FND_GLOBAL.conc_login_id);
947:
948: END LOOP;

Line 946: p_last_update_login => FND_GLOBAL.conc_login_id);

942: p_effective_to_date => SYSDATE,
943: p_active_flag => downg.active_flag,
944: p_last_updated_by => FND_GLOBAL.USER_ID,
945: p_last_update_date => SYSDATE,
946: p_last_update_login => FND_GLOBAL.conc_login_id);
947:
948: END LOOP;
949: END IF;
950: