APPS.ASO_QUOTE_TMPL_INT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

    P_LAST_UPDATE_DATE      IN   DATE,
    X_RETURN_STATUS         OUT NOCOPY /* file.sql.39 change */     VARCHAR2,
    X_MSG_COUNT             OUT NOCOPY /* file.sql.39 change */     NUMBER,
    X_MSG_DATA              OUT NOCOPY /* file.sql.39 change */     VARCHAR2
)
IS

l_QTE_HEADER_REC             ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

Line: 107

    P_UPDATE_FLAG           => 'Y',
    P_TEMPLATE_ID_TBL       => P_TEMPLATE_ID_TBL,
    P_QTE_HEADER_REC        => P_QTE_HEADER_REC,
    P_CONTROL_REC           => P_CONTROL_REC,
    x_Qte_Line_Tbl          => x_Qte_Line_Tbl,
    x_Qte_Line_Dtl_Tbl      => x_Qte_Line_Dtl_Tbl,
    X_RETURN_STATUS         => X_RETURN_STATUS,
    X_MSG_COUNT             => X_MSG_COUNT,
    X_MSG_DATA              => X_MSG_DATA
    );