796: business_group_id,
797: entity_id,
798: priority,
799: overwrite -- bug 4179734
800: from psb_defaults
801: where data_extract_id = p_src_data_extract_id;
802:
803: Cursor C_Position_Sets is
804: Select aps.name,
963: l_src_default_rule_id := C_Defaults_Rec.default_rule_id;
964: l_src_entity_id := C_Defaults_Rec.entity_id;
965:
966: Select count(*) into l_default_count
967: from psb_defaults
968: where name = C_Defaults_Rec.name
969: and data_extract_id = p_data_extract_id;
970:
971: If (l_default_count = 0) then
992: l_last_update_login,
993: l_created_by,
994: l_creation_date);
995:
996: Select psb_defaults_s.nextval
997: into l_default_rule_id
998: from dual;
999:
1000: PSB_DEFAULTS_PVT.Insert_Row(
996: Select psb_defaults_s.nextval
997: into l_default_rule_id
998: from dual;
999:
1000: PSB_DEFAULTS_PVT.Insert_Row(
1001: p_api_version => 1.0,
1002: p_init_msg_list => FND_API.G_FALSE,
1003: p_commit => FND_API.G_FALSE,
1004: p_validation_level => FND_API.G_VALID_LEVEL_FULL,