APPS.GMD_SEARCH_REPLACE_VERS dependencies on FND_ATTACHED_DOCUMENTS

Line 1102: CURSOR cur_form_att(cp_entity_name fnd_attached_documents.entity_name%TYPE,

1098: AND NOT EXISTS (SELECT 1
1099: FROM gmd_recipe_generation
1100: WHERE organization_id = V_orgn_id);
1101: --kkillams,bug 3738941
1102: CURSOR cur_form_att(cp_entity_name fnd_attached_documents.entity_name%TYPE,
1103: cp_pk1_value fnd_attached_documents.pk1_value%TYPE) IS
1104: SELECT 1
1105: FROM fnd_attached_documents fad
1106: WHERE fad.entity_name = cp_entity_name

Line 1103: cp_pk1_value fnd_attached_documents.pk1_value%TYPE) IS

1099: FROM gmd_recipe_generation
1100: WHERE organization_id = V_orgn_id);
1101: --kkillams,bug 3738941
1102: CURSOR cur_form_att(cp_entity_name fnd_attached_documents.entity_name%TYPE,
1103: cp_pk1_value fnd_attached_documents.pk1_value%TYPE) IS
1104: SELECT 1
1105: FROM fnd_attached_documents fad
1106: WHERE fad.entity_name = cp_entity_name
1107: AND fad.pk1_value = cp_pk1_value;

Line 1105: FROM fnd_attached_documents fad

1101: --kkillams,bug 3738941
1102: CURSOR cur_form_att(cp_entity_name fnd_attached_documents.entity_name%TYPE,
1103: cp_pk1_value fnd_attached_documents.pk1_value%TYPE) IS
1104: SELECT 1
1105: FROM fnd_attached_documents fad
1106: WHERE fad.entity_name = cp_entity_name
1107: AND fad.pk1_value = cp_pk1_value;
1108:
1109: l_formulaline_id fm_matl_dtl.formulaline_id%TYPE;

Line 1241: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(

1237: --Added following validation to copy the attachments
1238: OPEN cur_form_att('FM_FORM_MST_B',to_char(p_formula_id));
1239: FETCH cur_form_att INTO l_dummy;
1240: IF cur_form_att%FOUND THEN
1241: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1242: X_from_entity_name => 'FM_FORM_MST_B',
1243: X_from_pk1_value => TO_CHAR(p_formula_id),
1244: X_from_pk2_value => NULL,
1245: X_from_pk3_value => NULL,

Line 1307: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(

1303: --Added following validation to copy the attachments
1304: OPEN cur_form_att('FM_MATL_DTL',to_char(X_dtl_tbl(i).formulaline_id));
1305: FETCH cur_form_att INTO l_dummy;
1306: IF cur_form_att%FOUND THEN
1307: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1308: X_from_entity_name => 'FM_MATL_DTL',
1309: X_from_pk1_value => TO_CHAR(X_dtl_tbl(i).formulaline_id),
1310: X_from_pk2_value => NULL,
1311: X_from_pk3_value => NULL,