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.ASN_MIG_SALES_CREDITS_PVT dependencies on AS_OPPORTUNITY_PUB

Line 893: l_sc_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type;

889: IS
890: l_module_name CONSTANT VARCHAR2(256) :=
891: 'asn.plsql.asn_mig_sales_credits_pvt.Update_sc_for_rep';
892:
893: l_sc_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type;
894: l_sc_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;
895:
896: l_sc_amount NUMBER;
897:

Line 894: l_sc_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;

890: l_module_name CONSTANT VARCHAR2(256) :=
891: 'asn.plsql.asn_mig_sales_credits_pvt.Update_sc_for_rep';
892:
893: l_sc_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type;
894: l_sc_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;
895:
896: l_sc_amount NUMBER;
897:
898: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;

Line 898: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;

894: l_sc_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;
895:
896: l_sc_amount NUMBER;
897:
898: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
899: l_ll_tbl_count NUMBER;
900: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
901:
902: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;

Line 900: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;

896: l_sc_amount NUMBER;
897:
898: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
899: l_ll_tbl_count NUMBER;
900: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
901:
902: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
903:
904: CURSOR c_rep_quota_credits(p_lead_id NUMBER, p_credit_type_id NUMBER,

Line 902: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;

898: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
899: l_ll_tbl_count NUMBER;
900: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
901:
902: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
903:
904: CURSOR c_rep_quota_credits(p_lead_id NUMBER, p_credit_type_id NUMBER,
905: p_sf_id NUMBER, p_sg_id NUMBER) IS
906: SELECT * FROM as_sales_credits

Line 1001: AS_OPPORTUNITY_PUB.Modify_Sales_Credits(

997: l_sc_tbl(1).attribute13 := l_sc_select_rec.attribute13;
998: l_sc_tbl(1).attribute14 := l_sc_select_rec.attribute14;
999: l_sc_tbl(1).attribute15 := l_sc_select_rec.attribute15;
1000:
1001: AS_OPPORTUNITY_PUB.Modify_Sales_Credits(
1002: p_api_version_number => 2.0,
1003: p_init_msg_list => FND_API.G_FALSE,
1004: p_commit => FND_API.G_FALSE,
1005: p_validation_level => 90,

Line 1094: AS_OPPORTUNITY_PUB.Update_Opp_Lines(

1090: -- Update Lead Line Amounts
1091: l_header_rec.lead_id := p_lead_id;
1092:
1093: IF l_ll_tbl_count > 0 THEN
1094: AS_OPPORTUNITY_PUB.Update_Opp_Lines(
1095: p_api_version_number => 2.0,
1096: p_init_msg_list => FND_API.G_FALSE,
1097: p_commit => FND_API.G_FALSE,
1098: p_validation_level => 90,

Line 1160: l_sc_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type;

1156: IS
1157: l_module_name CONSTANT VARCHAR2(256) :=
1158: 'asn.plsql.asn_mig_sales_credits_pvt.Update_sc_for_rep';
1159:
1160: l_sc_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type;
1161: l_sc_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;
1162:
1163: l_sc_amount NUMBER;
1164:

Line 1161: l_sc_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;

1157: l_module_name CONSTANT VARCHAR2(256) :=
1158: 'asn.plsql.asn_mig_sales_credits_pvt.Update_sc_for_rep';
1159:
1160: l_sc_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type;
1161: l_sc_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;
1162:
1163: l_sc_amount NUMBER;
1164:
1165: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;

Line 1165: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;

1161: l_sc_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;
1162:
1163: l_sc_amount NUMBER;
1164:
1165: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
1166: l_ll_tbl_count NUMBER;
1167: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
1168:
1169: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;

Line 1167: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;

1163: l_sc_amount NUMBER;
1164:
1165: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
1166: l_ll_tbl_count NUMBER;
1167: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
1168:
1169: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
1170:
1171: CURSOR c_rep_quota_credits(p_lead_id NUMBER,p_lead_line_id NUMBER, p_credit_type_id NUMBER,

Line 1169: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;

1165: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
1166: l_ll_tbl_count NUMBER;
1167: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
1168:
1169: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
1170:
1171: CURSOR c_rep_quota_credits(p_lead_id NUMBER,p_lead_line_id NUMBER, p_credit_type_id NUMBER,
1172: p_sf_id NUMBER, p_sg_id NUMBER) IS
1173: SELECT * FROM as_sales_credits

Line 1269: AS_OPPORTUNITY_PUB.Modify_Sales_Credits(

1265: l_sc_tbl(1).attribute13 := l_sc_select_rec.attribute13;
1266: l_sc_tbl(1).attribute14 := l_sc_select_rec.attribute14;
1267: l_sc_tbl(1).attribute15 := l_sc_select_rec.attribute15;
1268:
1269: AS_OPPORTUNITY_PUB.Modify_Sales_Credits(
1270: p_api_version_number => 2.0,
1271: p_init_msg_list => FND_API.G_FALSE,
1272: p_commit => FND_API.G_FALSE,
1273: p_validation_level => 90,

Line 1362: AS_OPPORTUNITY_PUB.Update_Opp_Lines(

1358: -- Update Lead Line Amounts
1359: l_header_rec.lead_id := p_lead_id;
1360:
1361: IF l_ll_tbl_count > 0 THEN
1362: AS_OPPORTUNITY_PUB.Update_Opp_Lines(
1363: p_api_version_number => 2.0,
1364: p_init_msg_list => FND_API.G_FALSE,
1365: p_commit => FND_API.G_FALSE,
1366: p_validation_level => 90,

Line 1444: l_sales_credit_rec AS_OPPORTUNITY_PUB.Sales_Credit_Rec_type;

1440: l_new_status VARCHAR2(30);
1441: l_default_status VARCHAR2(30) := fnd_profile.value('AS_OPP_STATUS');
1442: l_new_total_amount NUMBER;
1443: l_tot_revenue_opp_forecast_amt NUMBER := FND_API.G_MISS_NUM; -- Added for ASNB
1444: l_sales_credit_rec AS_OPPORTUNITY_PUB.Sales_Credit_Rec_type;
1445:
1446: l_forecast_credit_type_id NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
1447: l_val NUMBER;
1448: l_date DATE;

Line 2133: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;

2129: l_total_percent NUMBER;
2130: l_total_credit NUMBER;
2131: l_line_amount NUMBER;
2132:
2133: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
2134: l_ll_tbl_count NUMBER;
2135: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
2136:
2137: l_obstacle_tbl AS_OPPORTUNITY_PUB.Obstacle_Tbl_Type;

Line 2135: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;

2131: l_line_amount NUMBER;
2132:
2133: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
2134: l_ll_tbl_count NUMBER;
2135: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
2136:
2137: l_obstacle_tbl AS_OPPORTUNITY_PUB.Obstacle_Tbl_Type;
2138: l_obstacle_tbl_count NUMBER;
2139: l_obstacle_out_tbl AS_OPPORTUNITY_PUB.Obstacle_Out_Tbl_Type;

Line 2137: l_obstacle_tbl AS_OPPORTUNITY_PUB.Obstacle_Tbl_Type;

2133: l_ll_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
2134: l_ll_tbl_count NUMBER;
2135: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
2136:
2137: l_obstacle_tbl AS_OPPORTUNITY_PUB.Obstacle_Tbl_Type;
2138: l_obstacle_tbl_count NUMBER;
2139: l_obstacle_out_tbl AS_OPPORTUNITY_PUB.Obstacle_Out_Tbl_Type;
2140:
2141: l_lead_line_id NUMBER;

Line 2139: l_obstacle_out_tbl AS_OPPORTUNITY_PUB.Obstacle_Out_Tbl_Type;

2135: l_ll_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
2136:
2137: l_obstacle_tbl AS_OPPORTUNITY_PUB.Obstacle_Tbl_Type;
2138: l_obstacle_tbl_count NUMBER;
2139: l_obstacle_out_tbl AS_OPPORTUNITY_PUB.Obstacle_Out_Tbl_Type;
2140:
2141: l_lead_line_id NUMBER;
2142: l_new_lead_line_id NUMBER;
2143: l_note_id NUMBER;

Line 2147: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;

2143: l_note_id NUMBER;
2144: l_new_note_context_id NUMBER;
2145: l_lead_opp_id NUMBER;
2146:
2147: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
2148:
2149: l_return_status VARCHAR2(16);
2150: l_msg_count NUMBER;
2151: l_msg_data VARCHAR2(1024);