DBA Data[Home] [Help]

APPS.GMD_VERSION_CONTROL dependencies on FND_ATTACHED_DOCUMENTS

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

1368: FROM fm_matl_dtl
1369: WHERE formula_id = p_formula_id;
1370:
1371: --kkillams,bug 3738941
1372: CURSOR cur_form_att(cp_entity_name fnd_attached_documents.entity_name%TYPE,
1373: cp_pk1_value fnd_attached_documents.pk1_value%TYPE) IS
1374: SELECT 1
1375: FROM fnd_attached_documents fad
1376: WHERE fad.entity_name = cp_entity_name

Line 1373: cp_pk1_value fnd_attached_documents.pk1_value%TYPE) IS

1369: WHERE formula_id = p_formula_id;
1370:
1371: --kkillams,bug 3738941
1372: CURSOR cur_form_att(cp_entity_name fnd_attached_documents.entity_name%TYPE,
1373: cp_pk1_value fnd_attached_documents.pk1_value%TYPE) IS
1374: SELECT 1
1375: FROM fnd_attached_documents fad
1376: WHERE fad.entity_name = cp_entity_name
1377: AND fad.pk1_value = cp_pk1_value;

Line 1375: FROM fnd_attached_documents fad

1371: --kkillams,bug 3738941
1372: CURSOR cur_form_att(cp_entity_name fnd_attached_documents.entity_name%TYPE,
1373: cp_pk1_value fnd_attached_documents.pk1_value%TYPE) IS
1374: SELECT 1
1375: FROM fnd_attached_documents fad
1376: WHERE fad.entity_name = cp_entity_name
1377: AND fad.pk1_value = cp_pk1_value;
1378:
1379: l_formulaline_id fm_matl_dtl.formulaline_id%TYPE;

Line 1498: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(

1494: --Added following validation to copy the attachments
1495: OPEN cur_form_att('FM_FORM_MST_B',to_char(p_formula_id));
1496: FETCH cur_form_att INTO l_dummy;
1497: IF cur_form_att%FOUND THEN
1498: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1499: X_from_entity_name => 'FM_FORM_MST_B',
1500: X_from_pk1_value => TO_CHAR(p_formula_id),
1501: X_from_pk2_value => NULL,
1502: X_from_pk3_value => NULL,

Line 1601: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(

1597: --Added following validation to copy the attachments
1598: OPEN cur_form_att('FM_MATL_DTL',to_char(X_dtl_tbl(i).formulaline_id));
1599: FETCH cur_form_att INTO l_dummy;
1600: IF cur_form_att%FOUND THEN
1601: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1602: X_from_entity_name => 'FM_MATL_DTL',
1603: X_from_pk1_value => TO_CHAR(X_dtl_tbl(i).formulaline_id),
1604: X_from_pk2_value => NULL,
1605: X_from_pk3_value => NULL,