eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_SALES_CREDIT_PVT dependencies on ASO_SALES_CREDITS

Line 505: FROM ASO_SALES_CREDITS

501: AND B.Source_Line_Id IS NOT NULL;
502:
503: CURSOR C_PSRep_Credit (l_qte_hdr NUMBER, l_res NUMBER, l_quota NUMBER) IS
504: SELECT Resource_Id
505: FROM ASO_SALES_CREDITS
506: WHERE Resource_Id = l_res
507: AND Quote_Header_Id = l_qte_Hdr
508: AND Sales_Credit_Type_Id = l_quota
509: AND Quote_Line_Id IS NULL;

Line 513: FROM ASO_SALES_CREDITS

509: AND Quote_Line_Id IS NULL;
510:
511: CURSOR C_PSRep_Credit_Line (l_qte_hdr NUMBER, l_res NUMBER, l_quota NUMBER, l_qte_line NUMBER) IS
512: SELECT Resource_Id
513: FROM ASO_SALES_CREDITS
514: WHERE Resource_Id = l_res
515: AND Quote_Header_Id = l_qte_Hdr
516: AND Sales_Credit_Type_Id = l_quota
517: AND Quote_Line_Id = l_qte_line;

Line 839: ASO_SALES_CREDITS_PKG.Delete_Header_Row ( P_Quote_Header_Id => p_Qte_Header_Rec.Quote_Header_Id );

835: IF aso_debug_pub.g_debug_flag = 'Y' THEN
836: aso_debug_pub.add('Get_Credits: l_credit_diff: '||l_credit_diff,1,'N');
837: END IF;
838: -- Delete existing credits for the quote
839: ASO_SALES_CREDITS_PKG.Delete_Header_Row ( P_Quote_Header_Id => p_Qte_Header_Rec.Quote_Header_Id );
840:
841: IF aso_debug_pub.g_debug_flag = 'Y' THEN
842: aso_debug_pub.add('Get_Credits: After Delete_Row ',1,'N');
843: END IF;

Line 845: INSERT INTO ASO_SALES_CREDITS (

841: IF aso_debug_pub.g_debug_flag = 'Y' THEN
842: aso_debug_pub.add('Get_Credits: After Delete_Row ',1,'N');
843: END IF;
844: -- Insert new credits for this quote
845: INSERT INTO ASO_SALES_CREDITS (
846: CREATION_DATE,
847: CREATED_BY,
848: LAST_UPDATED_BY,
849: LAST_UPDATE_DATE,

Line 865: ASO_SALES_CREDITS_S.nextval,

861: G_USER_ID,
862: G_USER_ID,
863: SYSDATE,
864: G_LOGIN_ID,
865: ASO_SALES_CREDITS_S.nextval,
866: B.Source_Id,
867: B.Source_Line_Id,
868: A.Allocation_Percentage,
869: A.Resource_Id,

Line 886: aso_debug_pub.add('Get_Credits: After Insert_Row to ASO_SALES_CREDITS ',1,'N');

882: AND B.Source_Line_Id IS NULL;
883:
884:
885: IF aso_debug_pub.g_debug_flag = 'Y' THEN
886: aso_debug_pub.add('Get_Credits: After Insert_Row to ASO_SALES_CREDITS ',1,'N');
887: END IF;
888: -- Update the primary salesrep percent in aso_sales_credits
889: IF l_credit_diff > 0 THEN
890: OPEN C_PSRep_Credit (p_Qte_Header_Rec.Quote_Header_Id, p_Qte_Header_Rec.Resource_Id, l_quota_id);

Line 888: -- Update the primary salesrep percent in aso_sales_credits

884:
885: IF aso_debug_pub.g_debug_flag = 'Y' THEN
886: aso_debug_pub.add('Get_Credits: After Insert_Row to ASO_SALES_CREDITS ',1,'N');
887: END IF;
888: -- Update the primary salesrep percent in aso_sales_credits
889: IF l_credit_diff > 0 THEN
890: OPEN C_PSRep_Credit (p_Qte_Header_Rec.Quote_Header_Id, p_Qte_Header_Rec.Resource_Id, l_quota_id);
891: FETCH C_PSRep_Credit INTO l_PSRep;
892: CLOSE C_PSRep_Credit;

Line 899: UPDATE ASO_SALES_CREDITS

895: aso_debug_pub.add('Get_Credits: l_PSRep '||l_PSRep,1,'N');
896: END IF;
897: IF l_PSRep IS NOT NULL THEN
898:
899: UPDATE ASO_SALES_CREDITS
900: SET Percent = Percent + l_credit_diff
901: WHERE Resource_Id = l_PSRep
902: AND Sales_Credit_Type_Id = l_quota_id
903: AND Quote_Header_Id = p_Qte_Header_Rec.Quote_Header_Id;

Line 906: aso_debug_pub.add('Get_Credits: After Update to ASO_SALES_CREDITS PSRep ',1,'N');

902: AND Sales_Credit_Type_Id = l_quota_id
903: AND Quote_Header_Id = p_Qte_Header_Rec.Quote_Header_Id;
904:
905: IF aso_debug_pub.g_debug_flag = 'Y' THEN
906: aso_debug_pub.add('Get_Credits: After Update to ASO_SALES_CREDITS PSRep ',1,'N');
907: END IF;
908: ELSE
909:
910: INSERT INTO ASO_SALES_CREDITS (

Line 910: INSERT INTO ASO_SALES_CREDITS (

906: aso_debug_pub.add('Get_Credits: After Update to ASO_SALES_CREDITS PSRep ',1,'N');
907: END IF;
908: ELSE
909:
910: INSERT INTO ASO_SALES_CREDITS (
911: CREATION_DATE,
912: CREATED_BY,
913: LAST_UPDATED_BY,
914: LAST_UPDATE_DATE,

Line 930: ASO_SALES_CREDITS_S.nextval,

926: G_USER_ID,
927: G_USER_ID,
928: SYSDATE,
929: G_LOGIN_ID,
930: ASO_SALES_CREDITS_S.nextval,
931: p_Qte_Header_Rec.Quote_Header_Id,
932: NULL,
933: l_credit_diff,
934: A.Resource_Id,

Line 944: aso_debug_pub.add('Get_Credits: After Insert to ASO_SALES_CREDITS PSRep ',1,'N');

940: WHERE A.Resource_Id = p_Qte_Header_Rec.Resource_Id
941: AND A.Quote_Number = p_qte_header_rec.Quote_Number;
942:
943: IF aso_debug_pub.g_debug_flag = 'Y' THEN
944: aso_debug_pub.add('Get_Credits: After Insert to ASO_SALES_CREDITS PSRep ',1,'N');
945: END IF;
946: END IF; -- l_PSRep
947:
948: END IF; -- l_credit_diff

Line 964: ASO_SALES_CREDITS_PKG.Delete_Row ( P_Quote_Line_Id => C_Get_Line_Rec.Quote_Line_Id );

960:
961: l_cred_line_diff := 100 - l_line_rev;
962:
963: -- Delete existing credits for the quote
964: ASO_SALES_CREDITS_PKG.Delete_Row ( P_Quote_Line_Id => C_Get_Line_Rec.Quote_Line_Id );
965:
966: IF aso_debug_pub.g_debug_flag = 'Y' THEN
967: aso_debug_pub.add('Get_Credits: After Delete_Row ',1,'N');
968: END IF;

Line 970: INSERT INTO ASO_SALES_CREDITS (

966: IF aso_debug_pub.g_debug_flag = 'Y' THEN
967: aso_debug_pub.add('Get_Credits: After Delete_Row ',1,'N');
968: END IF;
969: -- Insert new credits for this quote
970: INSERT INTO ASO_SALES_CREDITS (
971: CREATION_DATE,
972: CREATED_BY,
973: LAST_UPDATED_BY,
974: LAST_UPDATE_DATE,

Line 990: ASO_SALES_CREDITS_S.nextval,

986: G_USER_ID,
987: G_USER_ID,
988: SYSDATE,
989: G_LOGIN_ID,
990: ASO_SALES_CREDITS_S.nextval,
991: B.Source_Id,
992: B.Source_Line_Id,
993: A.Allocation_Percentage,
994: A.Resource_Id,

Line 1010: aso_debug_pub.add('Get_Credits: After Insert_Row to ASO_SALES_CREDITS ',1,'N');

1006: AND C.Quote_Number = p_qte_header_rec.Quote_Number
1007: AND B.Source_Line_Id = C_Get_Line_Rec.Quote_Line_Id;
1008:
1009: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1010: aso_debug_pub.add('Get_Credits: After Insert_Row to ASO_SALES_CREDITS ',1,'N');
1011: END IF;
1012: -- Update the primary salesrep percent in aso_sales_credits
1013: IF l_cred_line_diff > 0 THEN
1014:

Line 1012: -- Update the primary salesrep percent in aso_sales_credits

1008:
1009: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1010: aso_debug_pub.add('Get_Credits: After Insert_Row to ASO_SALES_CREDITS ',1,'N');
1011: END IF;
1012: -- Update the primary salesrep percent in aso_sales_credits
1013: IF l_cred_line_diff > 0 THEN
1014:
1015: l_PSRep := NULL;
1016:

Line 1024: UPDATE ASO_SALES_CREDITS

1020: CLOSE C_PSRep_Credit_Line;
1021:
1022: IF l_PSRep IS NOT NULL THEN
1023:
1024: UPDATE ASO_SALES_CREDITS
1025: SET Percent = Percent + l_credit_diff
1026: WHERE Resource_Id = l_PSRep
1027: AND Sales_Credit_Type_Id = l_quota_id
1028: AND Quote_Header_Id = p_Qte_Header_Rec.Quote_Header_Id

Line 1033: INSERT INTO ASO_SALES_CREDITS (

1029: AND Quote_Line_Id = C_Get_Line_Rec.Quote_Line_Id;
1030:
1031: ELSE
1032:
1033: INSERT INTO ASO_SALES_CREDITS (
1034: CREATION_DATE,
1035: CREATED_BY,
1036: LAST_UPDATED_BY,
1037: LAST_UPDATE_DATE,

Line 1053: ASO_SALES_CREDITS_S.nextval,

1049: G_USER_ID,
1050: G_USER_ID,
1051: SYSDATE,
1052: G_LOGIN_ID,
1053: ASO_SALES_CREDITS_S.nextval,
1054: p_Qte_Header_Rec.Quote_Header_Id,
1055: C_Get_Line_Rec.Quote_Line_Id,
1056: l_cred_line_diff,
1057: A.Resource_Id,