APPS.PSB_WRHR_EXTRACT_PROCESS dependencies on PSB_ENTITY_SET_S

Line 3761: l_set_of_books_id PSB_ENTITY_SET.SET_OF_BOOKS_ID%TYPE;

3757: l_msg_data VARCHAR2(1000);
3758: l_new_entity_set_id PSB_ENTITY_SET.ENTITY_SET_ID%TYPE;
3759: l_entity_type CONSTANT
3760: PSB_ENTITY_SET.ENTITY_TYPE%TYPE := 'DEFAULT_RULE';
3761: l_set_of_books_id PSB_ENTITY_SET.SET_OF_BOOKS_ID%TYPE;
3762: l_budget_group_id PSB_ENTITY_SET.BUDGET_GROUP_ID%TYPE;
3763: l_dummy_rowid VARCHAR2(100);
3764: l_name_already_exist NUMBER;
3765:

Line 3807: FOR l_entity_set_rec IN (SELECT psb_entity_set_s.NEXTVAL entity_set_id

3803: RAISE FND_API.G_EXC_ERROR;
3804: END IF;
3805:
3806: --get a new PSB_ENTITY_SET_ID for the new rule set
3807: FOR l_entity_set_rec IN (SELECT psb_entity_set_s.NEXTVAL entity_set_id
3808: FROM dual)
3809: LOOP
3810: l_new_entity_set_id := l_entity_set_rec.entity_set_id;
3811: END LOOP;