DBA Data[Home] [Help]

APPS.AMS_PS_RULE_PVT dependencies on AMS_IBA_PS_RULES_PKG

Line 311: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Insert_Row)

307: p_visitor_rec.rgoh is null AND
308: p_visitor_rec.rgnoh is null)
309: THEN
310:
311: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Insert_Row)
312:
313: IF p_ps_rules_rec.RULE_ID IS NULL OR p_ps_rules_rec.RULE_ID = FND_API.g_miss_num THEN
314:
315: LOOP

Line 329: AMS_IBA_PS_RULES_PKG.Insert_Row(

325: END LOOP;
326: END IF;
327:
328:
329: AMS_IBA_PS_RULES_PKG.Insert_Row(
330:
331: p_created_by => FND_GLOBAL.USER_ID,
332: p_creation_date => SYSDATE,
333: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 394: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Insert_Row)

390: EXIT WHEN l_dummy IS NULL;
391: END LOOP;
392: END IF;
393:
394: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Insert_Row)
395:
396: AMS_IBA_PS_RULES_PKG.Insert_Row(
397:
398: p_created_by => FND_GLOBAL.USER_ID,

Line 396: AMS_IBA_PS_RULES_PKG.Insert_Row(

392: END IF;
393:
394: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Insert_Row)
395:
396: AMS_IBA_PS_RULES_PKG.Insert_Row(
397:
398: p_created_by => FND_GLOBAL.USER_ID,
399: p_creation_date => SYSDATE,
400: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 925: AMS_IBA_PS_RULES_PKG.Insert_Row(

921: CLOSE c_id_exists;
922: EXIT WHEN l_dummy IS NULL;
923: END LOOP;
924:
925: AMS_IBA_PS_RULES_PKG.Insert_Row(
926: p_created_by => FND_GLOBAL.USER_ID,
927: p_creation_date => SYSDATE,
928: p_last_updated_by => FND_GLOBAL.USER_ID,
929: p_last_update_date => SYSDATE,

Line 978: AMS_IBA_PS_RULES_PKG.Insert_Row(

974: CLOSE c_id_exists;
975: EXIT WHEN l_dummy IS NULL;
976: END LOOP;
977:
978: AMS_IBA_PS_RULES_PKG.Insert_Row(
979: p_created_by => FND_GLOBAL.USER_ID,
980: p_creation_date => SYSDATE,
981: p_last_updated_by => FND_GLOBAL.USER_ID,
982: p_last_update_date => SYSDATE,

Line 1092: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Delete_Row)

1088:
1089: AMS_UTILITY_PVT.debug_message('Private API: Calling delete table handler');
1090: END IF;
1091:
1092: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Delete_Row)
1093: AMS_IBA_PS_RULES_PKG.Delete_Row(
1094: p_RULE_ID => p_RULE_ID);
1095: --
1096: -- End of API body

Line 1093: AMS_IBA_PS_RULES_PKG.Delete_Row(

1089: AMS_UTILITY_PVT.debug_message('Private API: Calling delete table handler');
1090: END IF;
1091:
1092: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Delete_Row)
1093: AMS_IBA_PS_RULES_PKG.Delete_Row(
1094: p_RULE_ID => p_RULE_ID);
1095: --
1096: -- End of API body
1097: --