1: PACKAGE BODY ASO_COPY_TMPL_PUB AS
2: /* $Header: asoptcpb.pls 120.4.12020000.2 2012/08/30 10:31:36 rassharm ship $ */
3: -- Start of Comments
4: -- Package name : ASO_COPY_TMPL_PUB
5: -- Purpose :
1: PACKAGE BODY ASO_COPY_TMPL_PUB AS
2: /* $Header: asoptcpb.pls 120.4.12020000.2 2012/08/30 10:31:36 rassharm ship $ */
3: -- Start of Comments
4: -- Package name : ASO_COPY_TMPL_PUB
5: -- Purpose :
6: -- This package body contains procedure for creating template from quote
7: -- Public API of Order Capture.
8: --
113:
114: -- ******************************************************************
115:
116: IF aso_debug_pub.g_debug_flag = 'Y' THEN
117: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Tmpl_to_tmpl ' , 1 , 'Y' );
118: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_header_id'||P_old_quote_header_Id , 1 , 'Y' );
119: end if;
120:
121: OPEN C_Qte_Number;
114: -- ******************************************************************
115:
116: IF aso_debug_pub.g_debug_flag = 'Y' THEN
117: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Tmpl_to_tmpl ' , 1 , 'Y' );
118: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_header_id'||P_old_quote_header_Id , 1 , 'Y' );
119: end if;
120:
121: OPEN C_Qte_Number;
122: FETCH C_Qte_Number INTO l_qte_header_rec.quote_number;
160:
161:
162:
163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
164: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl ' , 1 , 'Y' );
165: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_number'|| l_qte_header_rec.quote_number , 1 , 'Y' );
166: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl org_id'|| l_qte_header_rec.org_id , 1 , 'Y' );
167: end if;
168:
161:
162:
163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
164: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl ' , 1 , 'Y' );
165: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_number'|| l_qte_header_rec.quote_number , 1 , 'Y' );
166: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl org_id'|| l_qte_header_rec.org_id , 1 , 'Y' );
167: end if;
168:
169:
162:
163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
164: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl ' , 1 , 'Y' );
165: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_number'|| l_qte_header_rec.quote_number , 1 , 'Y' );
166: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl org_id'|| l_qte_header_rec.org_id , 1 , 'Y' );
167: end if;
168:
169:
170: l_qte_header_rec.TOTAL_LIST_PRICE := NULL;
1989: CLOSE line_id_from_config;
1990:
1991: end Config_Copy_Tmpl;
1992:
1993: end ASO_COPY_TMPL_PUB;