APPS.FNDCP_SCH dependencies on FND_CONC_REL_DISJ_MEMBERS

Line 1046: insert into FND_CONC_REL_DISJ_MEMBERS

1042:
1043: v_id := Val_id_f(null,State_Value,t_id);
1044:
1045:
1046: insert into FND_CONC_REL_DISJ_MEMBERS
1047: (DISJUNCTION_APPLICATION_ID, DISJUNCTION_ID, STATE_APPLICATION_ID,
1048: STATE_ID, STATUS_VALUE, NEGATION_FLAG,
1049: PERIOD_OR_STATE_FLAG, created_by,
1050: last_update_login, last_update_date, last_updated_by, creation_date)

Line 1114: insert into FND_CONC_REL_DISJ_MEMBERS

1110: d_app_id := application_id_f(Disj_Application);
1111: d_id := Disj_id_f(d_app_id,Disj_Name);
1112:
1113:
1114: insert into FND_CONC_REL_DISJ_MEMBERS
1115: (DISJUNCTION_APPLICATION_ID, DISJUNCTION_ID, PERIOD_APPLICATION_ID,
1116: PERIOD_ID,PERIOD_OR_STATE_FLAG,NEGATION_FLAG,created_by,
1117: last_update_login, last_update_date, last_updated_by, creation_date)
1118: Values

Line 1183: DELETE FROM FND_CONC_REL_DISJ_MEMBERS

1179: d_app_id := application_id_f(Disj_Application);
1180: d_id := Disj_id_f(d_app_id,Disj_Name);
1181:
1182:
1183: DELETE FROM FND_CONC_REL_DISJ_MEMBERS
1184: WHERE DISJUNCTION_APPLICATION_ID = d_app_id
1185: AND DISJUNCTION_ID = d_id
1186: AND PERIOD_OR_STATE_FLAG = Member_Type
1187: AND DECODE(Member_Type, 'S', STATE_APPLICATION_ID,

Line 1248: from fnd_conc_rel_disj_members

1244:
1245: begin
1246: select 'Y'
1247: into dummy
1248: from fnd_conc_rel_disj_members
1249: where DISJUNCTION_APPLICATION_ID = d_app_id
1250: and DISJUNCTION_ID = d_id
1251: and PERIOD_OR_STATE_FLAG = Member_Type
1252: AND DECODE(Member_Type, 'S', STATE_APPLICATION_ID,