APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_SALES_CREDITS

Line 1249: ASO_SALES_CREDITS_PKG.Insert_Row(

1245: l_sales_credit_rec.quote_header_id := x_qte_header_rec.quote_header_id;
1246: x_sales_credit_tbl(i) := l_sales_credit_rec;
1247: -- BC4J Fix
1248: --x_sales_credit_tbl(i).sales_credit_id := NULL;
1249: ASO_SALES_CREDITS_PKG.Insert_Row(
1250: p_CREATION_DATE => SYSDATE,
1251: p_CREATED_BY => G_USER_ID,
1252: p_LAST_UPDATED_BY => G_USER_ID,
1253: p_LAST_UPDATE_DATE => SYSDATE,

Line 3082: ASO_SALES_CREDITS_PKG.Insert_Row(

3078: IF l_sales_credit_rec.operation_code = 'CREATE' THEN
3079: l_sales_credit_rec.quote_header_id := l_qte_header_id;
3080: -- BC4J Fix
3081: --x_sales_credit_tbl(i).sales_credit_id := NULL;
3082: ASO_SALES_CREDITS_PKG.Insert_Row(
3083: p_CREATION_DATE => SYSDATE,
3084: p_CREATED_BY => G_USER_ID,
3085: p_LAST_UPDATED_BY => G_USER_ID,
3086: p_LAST_UPDATE_DATE => SYSDATE,

Line 3127: ASO_SALES_CREDITS_PKG.Update_Row(

3123: p_CREDIT_RULE_ID => l_sales_CREDIT_rec.CREDIT_RULE_ID,
3124: p_OBJECT_VERSION_NUMBER => l_sales_CREDIT_rec.OBJECT_VERSION_NUMBER);
3125:
3126: ELSIF l_sales_credit_rec.operation_code = 'UPDATE' THEN
3127: ASO_SALES_CREDITS_PKG.Update_Row(
3128: p_CREATION_DATE => l_sales_CREDIT_rec.creation_date,
3129: p_CREATED_BY => G_USER_ID,
3130: p_LAST_UPDATED_BY => G_USER_ID,
3131: p_LAST_UPDATE_DATE => SYSDATE,

Line 3171: ASO_SALES_CREDITS_PKG.Delete_Row(

3167: p_SYSTEM_ASSIGNED_FLAG => 'N',
3168: p_CREDIT_RULE_ID => l_sales_CREDIT_rec.CREDIT_RULE_ID,
3169: p_OBJECT_VERSION_NUMBER => l_sales_CREDIT_rec.OBJECT_VERSION_NUMBER);
3170: ELSIF l_sales_credit_rec.operation_code = 'DELETE' THEN
3171: ASO_SALES_CREDITS_PKG.Delete_Row(
3172: p_SALES_CREDIT_ID => l_SALES_CREDIT_rec.SALES_CREDIT_ID);
3173:
3174: END IF;
3175: END LOOP;

Line 5314: ASO_SALES_CREDITS_PKG.Insert_Row(

5310: if aso_debug_pub.g_debug_flag = 'Y' then
5311: aso_debug_pub.add('Create_Quote: After assigning x_hd_sales_credit_tbl.count: '|| x_hd_sales_credit_tbl.count);
5312: end if;
5313:
5314: ASO_SALES_CREDITS_PKG.Insert_Row(
5315: p_CREATION_DATE => SYSDATE,
5316: p_CREATED_BY => G_USER_ID,
5317: p_LAST_UPDATED_BY => G_USER_ID,
5318: p_LAST_UPDATE_DATE => SYSDATE,

Line 6832: FROM ASO_SALES_CREDITS

6828: WHERE Quota_Flag = 'Y';
6829:
6830: CURSOR C_Get_SCredit_Exists(l_qte_hdr_id NUMBER) IS
6831: SELECT 'Y'
6832: FROM ASO_SALES_CREDITS
6833: WHERE quote_header_id = l_qte_hdr_id;
6834:
6835: CURSOR c_tax_line(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS
6836: select nvl(sum(nvl(tax_amount, 0)),0) tax_amount

Line 8440: ASO_SALES_CREDITS_PKG.Insert_Row(

8436: aso_debug_pub.add('l_quota_id: '||l_quota_id);
8437: x_hd_sales_credit_tbl(1) := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_REC;
8438: aso_debug_pub.add('after assign x_hd_sales_credit_tbl.count: '||x_hd_sales_credit_tbl.count);
8439:
8440: ASO_SALES_CREDITS_PKG.Insert_Row(
8441: p_CREATION_DATE => SYSDATE,
8442: p_CREATED_BY => G_USER_ID,
8443: p_LAST_UPDATED_BY => G_USER_ID,
8444: p_LAST_UPDATE_DATE => SYSDATE,

Line 10701: DELETE FROM ASO_SALES_CREDITS

10697:
10698: DELETE FROM ASO_TAX_DETAILS
10699: WHERE QUOTE_HEADER_ID = p_qte_header_id;
10700:
10701: DELETE FROM ASO_SALES_CREDITS
10702: WHERE QUOTE_HEADER_ID = p_qte_header_id;
10703:
10704:
10705: DELETE FROM ASO_QUOTE_PARTIES