APPS.ASO_SALES_CREDIT_PVT dependencies on CN_SCA_LINES_INTERFACE_GTT

Line 558: DELETE FROM CN_SCA_LINES_INTERFACE_GTT;

554: aso_debug_pub.add('Get_Credits: attribute1: '||(NVL(p_qte_header_rec.Total_Quote_Price,0) - (NVL(p_qte_header_rec.Total_Tax,0) + NVL(p_qte_header_rec.Total_Shipping_Charge,0))),1,'N');
555: END IF;
556:
557: -- Truncate temp tables
558: DELETE FROM CN_SCA_LINES_INTERFACE_GTT;
559:
560: DELETE FROM CN_SCA_HEADERS_INTERFACE_GTT;
561:
562: DELETE FROM CN_SCA_LINES_OUTPUT_GTT;

Line 713: -- Populate CN_SCA_LINES_INTERFACE_GTT

709:
710: IF aso_debug_pub.g_debug_flag = 'Y' THEN
711: aso_debug_pub.add('Get_Credits: Before insert line interface tbl ',1,'N');
712: END IF;
713: -- Populate CN_SCA_LINES_INTERFACE_GTT
714: INSERT INTO CN_SCA_LINES_INTERFACE_GTT (
715: SCA_LINES_INTERFACE_ID,
716: SCA_HEADERS_INTERFACE_ID,
717: SCA_BATCH_ID,

Line 714: INSERT INTO CN_SCA_LINES_INTERFACE_GTT (

710: IF aso_debug_pub.g_debug_flag = 'Y' THEN
711: aso_debug_pub.add('Get_Credits: Before insert line interface tbl ',1,'N');
712: END IF;
713: -- Populate CN_SCA_LINES_INTERFACE_GTT
714: INSERT INTO CN_SCA_LINES_INTERFACE_GTT (
715: SCA_LINES_INTERFACE_ID,
716: SCA_HEADERS_INTERFACE_ID,
717: SCA_BATCH_ID,
718: RESOURCE_ID,

Line 721: SELECT CN_SCA_LINES_INTERFACE_GTT_S.NextVal,

717: SCA_BATCH_ID,
718: RESOURCE_ID,
719: ROLE_ID,
720: SOURCE_TRX_ID )
721: SELECT CN_SCA_LINES_INTERFACE_GTT_S.NextVal,
722: B.SCA_Headers_Interface_Id,
723: l_batch_id,
724: A.Resource_Id,
725: A.Role_Id,

Line 756: select count(*) into l_dumb from CN_SCA_LINES_INTERFACE_GTT;

752: aso_debug_pub.add('Get_Credits: tmp credit_rule_id: '||C_Hd_Rec.credit_rule_id,1,'N');
753: aso_debug_pub.add('Get_Credits: tmp process_status: '||C_Hd_Rec.process_status,1,'N');
754: END LOOP;
755: END IF;
756: select count(*) into l_dumb from CN_SCA_LINES_INTERFACE_GTT;
757: aso_debug_pub.add('Get_Credits: l_lines: '||l_dumb,1,'N');
758: END IF;
759:
760: IF aso_debug_pub.g_debug_flag = 'Y' THEN