APPS.GMD_EBI_RECIPE_PUB dependencies on FM_FORM_MST_B

Line 223: SELECT Max(formula_id) INTO l_form_id FROM fm_form_mst_b WHERE formula_no = p_input.formula_header.formula_no;

219: line_ctr NUMBER := 1;
220: BEGIN
221: IF ( status_flag IN ( FND_API.G_RET_STS_SUCCESS,'Q')) THEN
222: IF ( p_input.formula_header.FORMULA_ID IS NULL ) THEN
223: SELECT Max(formula_id) INTO l_form_id FROM fm_form_mst_b WHERE formula_no = p_input.formula_header.formula_no;
224: ELSE
225: l_form_id := p_input.formula_header.FORMULA_ID;
226: END IF;
227: FOR j IN 1..p_input.formula_details.Count LOOP

Line 1094: l_entity_name varchar2(100) := 'FM_FORM_MST_B';

1090: l_security_tp number := 4;
1091: l_publish_flag varchar2(1) := 'Y';
1092: l_usage_type varchar2(1) := 'S';
1093: l_description varchar2(100) := 'ROUTING DETAILS';
1094: l_entity_name varchar2(100) := 'FM_FORM_MST_B';
1095: l_aut_add_flag varchar2(1) := 'N';
1096: l_row_id1 varchar2(255);
1097: l_row_id2 varchar2(255);
1098: l_document_id number;

Line 1182: SELECT Max(formula_id) INTO l_formula_id FROM fm_form_mst_b WHERE formula_no=p_recipe_obj.formula_obj.formula_header.FORMULA_no;

1178: END IF;
1179: END LOOP;
1180:
1181: IF ( p_recipe_obj.formula_obj.formula_header.FORMULA_ID IS NULL ) THEN
1182: SELECT Max(formula_id) INTO l_formula_id FROM fm_form_mst_b WHERE formula_no=p_recipe_obj.formula_obj.formula_header.FORMULA_no;
1183: ELSE
1184: l_formula_id := p_recipe_obj.formula_obj.formula_header.FORMULA_ID;
1185: END IF;
1186: l_attchmt_exits := fnd_attachment_util_pkg.get_atchmt_exists(l_entity_name => 'FM_FORM_MST_B'

Line 1186: l_attchmt_exits := fnd_attachment_util_pkg.get_atchmt_exists(l_entity_name => 'FM_FORM_MST_B'

1182: SELECT Max(formula_id) INTO l_formula_id FROM fm_form_mst_b WHERE formula_no=p_recipe_obj.formula_obj.formula_header.FORMULA_no;
1183: ELSE
1184: l_formula_id := p_recipe_obj.formula_obj.formula_header.FORMULA_ID;
1185: END IF;
1186: l_attchmt_exits := fnd_attachment_util_pkg.get_atchmt_exists(l_entity_name => 'FM_FORM_MST_B'
1187: ,l_pkey1 => l_formula_id
1188: ,l_pkey3 => null
1189: ,l_pkey4 => null
1190: ,l_pkey5 => null

Line 1258: WHERE ENTITY_NAME ='FM_FORM_MST_B' AND PK1_VALUE = l_formula_id;

1254: ELSE
1255:
1256: SELECT * INTO l_attached_doc
1257: FROM FND_ATTACHED_DOCUMENTS
1258: WHERE ENTITY_NAME ='FM_FORM_MST_B' AND PK1_VALUE = l_formula_id;
1259:
1260: SELECT * INTO l_doc
1261: FROM fnd_documents
1262: WHERE document_id = l_attached_doc.document_id;

Line 1537: SELECT Max(formula_vers)+1 INTO l_form_version FROM fm_form_mst_b WHERE formula_no = p_formula_obj.formula_header.formula_no;

1533: l_form_type := p_formula_obj.formula_header.formula_type;
1534: END IF;
1535: FOR j in 1..p_formula_obj.formula_details.COUNT LOOP
1536: IF ( p_formula_obj.formula_header.formula_id is NULL ) THEN
1537: SELECT Max(formula_vers)+1 INTO l_form_version FROM fm_form_mst_b WHERE formula_no = p_formula_obj.formula_header.formula_no;
1538: IF l_form_version IS NULL THEN
1539: l_form_version:=1;
1540: END IF;
1541: l_formula_insert_header_rec.formula_id := p_formula_obj.formula_header.formula_id;