APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_SUP_TMPL_INSTANCE

Line 5241: FROM aso_sup_tmpl_instance

5237: CURSOR get_template_id (
5238: qte_header_id NUMBER
5239: ) IS
5240: SELECT template_instance_id, template_id
5241: FROM aso_sup_tmpl_instance
5242: WHERE owner_table_name = 'ASO_QUOTE_HEADERS'
5243: AND owner_table_id = qte_header_id;
5244:
5245: CURSOR get_values (

Line 5296: -- Create a new row in the ASO_SUP_TMPL_INSTANCE Table with the template id

5292: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5293: aso_debug_pub.ADD ( 'Template Id : ' || TO_CHAR ( template_val.template_id ) , 1 , 'N' );
5294: aso_debug_pub.ADD ( ' Old Template Instance Id : ' || TO_CHAR ( template_val.template_instance_id ) , 1 , 'N' );
5295:
5296: -- Create a new row in the ASO_SUP_TMPL_INSTANCE Table with the template id
5297:
5298: aso_debug_pub.ADD ( 'Inserting a row into tmpl_instance table' , 1 , 'N' );
5299: END IF;
5300:

Line 5305: ASO_SUP_TMPL_INSTANCE_PKG.INSERT_ROW (

5301: -- Initiate the variable to null,
5302: -- so that each time they contain new value for every pass of loop
5303:
5304: l_new_template_instance_id := NULL;
5305: ASO_SUP_TMPL_INSTANCE_PKG.INSERT_ROW (
5306: PX_ROWID => l_template_instance_rowid
5307: , PX_TEMPLATE_INSTANCE_ID => l_new_template_instance_id
5308: , P_created_by => FND_GLOBAL.USER_ID
5309: , P_creation_date => SYSDATE

Line 6781: FROM aso_sup_tmpl_instance

6777: CURSOR get_template_id (
6778: qte_line_id NUMBER
6779: ) IS
6780: SELECT template_instance_id, template_id
6781: FROM aso_sup_tmpl_instance
6782: WHERE owner_table_name = 'ASO_QUOTE_LINES'
6783: AND owner_table_id = qte_line_id;
6784:
6785: CURSOR get_values (

Line 6837: -- Create a new row in the ASO_SUP_TMPL_INSTANCE Table with the template id

6833: aso_debug_pub.ADD ( 'Template Id : ' || TO_CHAR ( template_val.template_id ) , 1 , 'N' );
6834: aso_debug_pub.ADD ( ' Old Template Instance Id : ' || TO_CHAR ( template_val.template_instance_id ) , 1 , 'N
6835: ' );
6836:
6837: -- Create a new row in the ASO_SUP_TMPL_INSTANCE Table with the template id
6838:
6839: aso_debug_pub.ADD ( 'Inserting a row into tmpl_instance table' , 1 , 'N' );
6840: END IF;
6841:

Line 6846: ASO_SUP_TMPL_INSTANCE_PKG.INSERT_ROW (

6842: -- Initiate the variable to null,
6843: -- so that each time they contain new value for every pass of loop
6844:
6845: l_new_template_instance_id := NULL;
6846: ASO_SUP_TMPL_INSTANCE_PKG.INSERT_ROW (
6847: PX_ROWID => l_template_instance_rowid
6848: , PX_TEMPLATE_INSTANCE_ID => l_new_template_instance_id
6849: , P_created_by => FND_GLOBAL.USER_ID
6850: , P_creation_date => SYSDATE