APPS.GMD_SUBSTITUTION_PUB dependencies on GMD_FORMULA_SUBSTITUTION

Line 98: , p_formula_substitution_tbl IN gmd_formula_substitution_tab

94: , p_init_msg_list IN VARCHAR2
95: , p_commit IN VARCHAR2
96: , p_substitution_hdr_rec IN gmd_substitution_hdr_rec_type
97: , p_substitution_dtl_rec IN gmd_substitution_dtl_rec_type
98: , p_formula_substitution_tbl IN gmd_formula_substitution_tab
99: , x_message_count OUT NOCOPY NUMBER
100: , x_message_list OUT NOCOPY VARCHAR2
101: , x_return_status OUT NOCOPY VARCHAR2
102: ) IS

Line 158: l_formula_substitution_tbl gmd_formula_substitution_tab;

154: -- get a record type
155: l_substitution_hdr_rec gmd_substitution_hdr_rec_type;
156: l_substitution_dtl_rec gmd_substitution_dtl_rec_type;
157: l_formula_substitution_rec gmd_fmsubstitution_rec_type;
158: l_formula_substitution_tbl gmd_formula_substitution_tab;
159:
160: -- Exception declaration
161: substitution_creation_failure EXCEPTION;
162: invalid_version EXCEPTION;

Line 661: , p_formula_substitution_tbl IN gmd_formula_substitution_tab

657: , p_commit IN VARCHAR2
658: , p_substitution_id IN NUMBER Default NULL
659: , p_substitution_name IN VARCHAR2 Default NULL
660: , p_substitution_version IN NUMBER Default NULL
661: , p_formula_substitution_tbl IN gmd_formula_substitution_tab
662: , x_message_count OUT NOCOPY NUMBER
663: , x_message_list OUT NOCOPY VARCHAR2
664: , x_return_status OUT NOCOPY VARCHAR2
665: ) IS

Line 670: From gmd_formula_substitution

666: -- Cursor definition
667: CURSOR validate_formula_substitution(vSubstitution_id NUMBER
668: ,vFormula_id NUMBER) IS
669: Select 1
670: From gmd_formula_substitution
671: Where formula_id = vformula_id
672: AND substitution_id = vSubstitution_id;
673:
674: -- local variable

Line 680: l_formula_substitution_tbl gmd_formula_substitution_tab;

676: l_formula_substitution_rec gmd_fmsubstitution_rec_type;
677: l_api_name CONSTANT VARCHAR2(30) := 'Create_formula_association';
678:
679: l_substitution_id NUMBER;
680: l_formula_substitution_tbl gmd_formula_substitution_tab;
681:
682: -- Exception declaration
683: substitution_creation_failure EXCEPTION;
684: invalid_version EXCEPTION;

Line 1483: FROM gmd_formula_substitution

1479:
1480: CURSOR get_formula_substitution_id(vSubstitution_id NUMBER
1481: ,vformula_id NUMBER) IS
1482: SELECT formula_substitution_id
1483: FROM gmd_formula_substitution
1484: WHERE substitution_id = vSubstitution_id
1485: AND formula_id = vformula_id;
1486:
1487: CURSOR get_formula_subs_info(vformula_Substitution_id NUMBER) IS

Line 1489: FROM gmd_formula_substitution

1485: AND formula_id = vformula_id;
1486:
1487: CURSOR get_formula_subs_info(vformula_Substitution_id NUMBER) IS
1488: SELECT substitution_id
1489: FROM gmd_formula_substitution
1490: WHERE formula_substitution_id = vformula_Substitution_id;
1491:
1492: l_formula_substitution_id NUMBER;
1493: l_substitution_id NUMBER;