[Home] [Help]
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:
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;
898: -- extract
899: CURSOR l_entity_assignment_csr
900: IS
901: SELECT *
902: FROM psb_entity_assignment
903: WHERE entity_set_id = l_entity_set_id;
904: /* End bug no 1308558 */
905:
906: BEGIN
1325: FOR l_entity_assignment_rec IN l_entity_assignment_csr
1326: LOOP
1327:
1328: -- insert the data into entity assignment table
1329: PSB_ENTITY_ASSIGNMENT_PVT.Insert_Row (
1330: p_api_version => 1.0,
1331: p_init_msg_list => FND_API.G_FALSE,
1332: p_commit => FND_API.G_FALSE,
1333: p_validation_level => FND_API.G_VALID_LEVEL_FULL,