APPS.PSB_COPY_DATA_EXTRACT_PVT dependencies on PSB_ENTITY_S

Line 743: -- PSB_ENTITY_SET AND PSB_ENTITY_ASSIGNMENT

739: l_rowid3 varchar2(100);
740:
741: /* Start bug no 1308558 */
742: -- These rowid's are needed for
743: -- PSB_ENTITY_SET AND PSB_ENTITY_ASSIGNMENT
744: l_rowid4 VARCHAR2(1000);
745: l_rowid5 VARCHAR2(1000);
746: /* End bug no 1308558 */
747:

Line 774: -- PSB_ENTITY_SET AND PSB_ENTITY_ASSIGNMENT

770: l_restart_id number;
771:
772: /* Start bug no 1308558 */
773: -- local variables needed for
774: -- PSB_ENTITY_SET AND PSB_ENTITY_ASSIGNMENT
775: l_ext_default_rule_id NUMBER;
776: l_entity_set_id NUMBER;
777: l_new_entity_set_id NUMBER;
778: l_business_group_id NUMBER;

Line 891: FROM psb_entity_set

887: -- entity sets associated with source data extract
888: CURSOR l_entity_set_csr
889: IS
890: SELECT *
891: FROM psb_entity_set
892: WHERE data_extract_id = p_src_data_extract_id
893: AND entity_type = 'DEFAULT_RULE';
894:
895:

Line 972: SELECT psb_entity_s.nextval

968: where name = C_Defaults_Rec.name
969: and data_extract_id = p_data_extract_id;
970:
971: If (l_default_count = 0) then
972: SELECT psb_entity_s.nextval
973: INTO l_entity_id
974: FROM dual;
975:
976: INSERT INTO psb_entity

Line 1253: FOR l_new_entity_rec IN (SELECT PSB_ENTITY_SET_S.NEXTVAL entity_set_id

1249: -- bug 4273111.
1250: l_exec_from_position := l_entity_set_rec.executable_from_position;
1251:
1252: -- generate the sequence for new entity sets
1253: FOR l_new_entity_rec IN (SELECT PSB_ENTITY_SET_S.NEXTVAL entity_set_id
1254: FROM dual)
1255: LOOP
1256: l_new_entity_set_id := l_new_entity_rec.entity_set_id;
1257: END LOOP;

Line 1281: -- call the insert procedure PSB_ENTITY_SET.INSERT_ROW

1277: FND_MESSAGE.set_token('RULE_SET_NAME', l_entity_set_rec.name);
1278: l_message_name := FND_MESSAGE.get||'-'||p_data_extract_id;
1279:
1280: l_return_status := null;
1281: -- call the insert procedure PSB_ENTITY_SET.INSERT_ROW
1282: PSB_ENTITY_SET_PVT.Insert_Row
1283: (p_api_version => 1.0,
1284: p_init_msg_list => FND_API.G_FALSE,
1285: p_commit => FND_API.G_FALSE,

Line 1282: PSB_ENTITY_SET_PVT.Insert_Row

1278: l_message_name := FND_MESSAGE.get||'-'||p_data_extract_id;
1279:
1280: l_return_status := null;
1281: -- call the insert procedure PSB_ENTITY_SET.INSERT_ROW
1282: PSB_ENTITY_SET_PVT.Insert_Row
1283: (p_api_version => 1.0,
1284: p_init_msg_list => FND_API.G_FALSE,
1285: p_commit => FND_API.G_FALSE,
1286: p_validation_level => FND_API.G_VALID_LEVEL_FULL,