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.CN_COLLECTION_AIA_PUB dependencies on FND_API

Line 30: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

26:
27: PROCEDURE loadrow_om
28: (
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
31: p_commit IN VARCHAR2:= FND_API.G_FALSE,
32: p_aia_rec_tbl IN CN_COLLECTION_AIA_PUB.aia_rec_tbl_type,
33: p_org_id IN NUMBER,
34: x_msg_count OUT nocopy NUMBER,

Line 31: p_commit IN VARCHAR2:= FND_API.G_FALSE,

27: PROCEDURE loadrow_om
28: (
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
31: p_commit IN VARCHAR2:= FND_API.G_FALSE,
32: p_aia_rec_tbl IN CN_COLLECTION_AIA_PUB.aia_rec_tbl_type,
33: p_org_id IN NUMBER,
34: x_msg_count OUT nocopy NUMBER,
35: x_msg_data OUT nocopy VARCHAR2,

Line 118: x_return_status := FND_API.G_RET_STS_SUCCESS;

114: debugmsg('CN_COLLECTION_AIA_PUB.loadrow_om api:p_org_id: ' || p_org_id);
115: debugmsg('CN_COLLECTION_AIA_PUB.loadrow_om api: p_api_version: ' || p_api_version);
116:
117: -- Initialize API return status to success
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119:
120: -- Standard call to check for call compatibility.
121: IF NOT FND_API.Compatible_API_Call ( l_api_version , p_api_version , l_api_name , G_PKG_NAME ) THEN
122: x_return_status := 'F';

Line 121: IF NOT FND_API.Compatible_API_Call ( l_api_version , p_api_version , l_api_name , G_PKG_NAME ) THEN

117: -- Initialize API return status to success
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119:
120: -- Standard call to check for call compatibility.
121: IF NOT FND_API.Compatible_API_Call ( l_api_version , p_api_version , l_api_name , G_PKG_NAME ) THEN
122: x_return_status := 'F';
123: x_msg_count := 1;
124: l_error_msg := 'p_api_version' || g_error_msg;
125: debugmsg('CN_COLLECTION_AIA_PUB.loadrow_om api: l_error_msg: ' || l_error_msg);

Line 143: IF FND_API.to_Boolean( p_init_msg_list ) THEN

139: --DBMS_OUTPUT.put_line('p_org_id ' || p_org_id);
140: mo_global.set_policy_context('S',p_org_id);
141:
142: -- Initialize message list if p_init_msg_list is set to TRUE.
143: IF FND_API.to_Boolean( p_init_msg_list ) THEN
144: FND_MSG_PUB.initialize;
145: END IF;
146:
147: IF p_aia_rec_tbl.COUNT = 0

Line 313: p_aia_rec_tbl(l_counter).PROCESSED_DATE = FND_API.G_MISS_CHAR) THEN

309:
310:
311: --Mandatory fields validation starts here
312: IF(p_aia_rec_tbl(l_counter).PROCESSED_DATE IS NULL or
313: p_aia_rec_tbl(l_counter).PROCESSED_DATE = FND_API.G_MISS_CHAR) THEN
314: x_return_status := 'F';
315: x_msg_count := 1;
316: l_error_msg := 'p_processed_date' || g_error_msg;
317: debugmsg('CN_COLLECTION_AIA_PUB.loadrow_om api: l_error_msg: ' || l_error_msg);

Line 331: p_aia_rec_tbl(l_counter).BOOKED_DATE = FND_API.G_MISS_CHAR) THEN

327: RAISE CN_AIA_REQ_FIELD_NOT_SET_ERROR;
328: END IF;
329:
330: IF(p_aia_rec_tbl(l_counter).BOOKED_DATE IS NULL or
331: p_aia_rec_tbl(l_counter).BOOKED_DATE = FND_API.G_MISS_CHAR) THEN
332: x_return_status := 'F';
333: x_msg_count := 1;
334: l_error_msg := 'p_booked_date' || g_error_msg;
335: debugmsg('CN_COLLECTION_AIA_PUB.loadrow_om api: l_error_msg: ' || l_error_msg);

Line 349: AND p_aia_rec_tbl(l_counter).SALESREP_ID = G_LOC_MISS_NUM AND p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER = FND_API.G_MISS_CHAR) THEN

345: RAISE CN_AIA_REQ_FIELD_NOT_SET_ERROR;
346: END IF;
347:
348: IF(p_aia_rec_tbl(l_counter).SALESREP_ID IS NULL AND p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER IS NULL
349: AND p_aia_rec_tbl(l_counter).SALESREP_ID = G_LOC_MISS_NUM AND p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER = FND_API.G_MISS_CHAR) THEN
350: x_return_status := 'F';
351: x_msg_count := 1;
352: l_error_msg := 'Any one of p_salesrep_id or p_employee_number' || g_error_msg;
353: debugmsg('CN_COLLECTION_AIA_PUB.loadrow_om api: l_error_msg: ' || l_error_msg);

Line 359: IF(p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER IS NOT NULL and p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER <> FND_API.G_MISS_CHAR) THEN

355: END IF;
356:
357:
358:
359: IF(p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER IS NOT NULL and p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER <> FND_API.G_MISS_CHAR) THEN
360: FOR l_resnum_srcnum_cr IN get_res_num_from_src_num(p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER)
361: LOOP
362: l_salesrep_number := l_resnum_srcnum_cr.employee_number;
363: END LOOP;

Line 568: decode(p_aia_rec_tbl(l_counter).INVOICE_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).INVOICE_DATE, 'dd/mm/yyyy hh24:mi:ss')),

564: l_salesrep_id ,
565: l_employee_number ,
566: to_date(p_aia_rec_tbl(l_counter).PROCESSED_DATE, 'dd/mm/yyyy hh24:mi:ss'),
567: p_aia_rec_tbl(l_counter).INVOICE_NUMBER ,
568: decode(p_aia_rec_tbl(l_counter).INVOICE_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).INVOICE_DATE, 'dd/mm/yyyy hh24:mi:ss')),
569: p_aia_rec_tbl(l_counter).TRANSACTION_AMOUNT ,
570: p_aia_rec_tbl(l_counter).TRANSACTION_CURRENCY_CODE ,
571: 'AIA_OM' ,
572: decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE', p_aia_rec_tbl(l_counter).REVENUE_TYPE),

Line 572: decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE', p_aia_rec_tbl(l_counter).REVENUE_TYPE),

568: decode(p_aia_rec_tbl(l_counter).INVOICE_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).INVOICE_DATE, 'dd/mm/yyyy hh24:mi:ss')),
569: p_aia_rec_tbl(l_counter).TRANSACTION_AMOUNT ,
570: p_aia_rec_tbl(l_counter).TRANSACTION_CURRENCY_CODE ,
571: 'AIA_OM' ,
572: decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE', p_aia_rec_tbl(l_counter).REVENUE_TYPE),
573: l_salesrep_number ,
574: p_aia_rec_tbl(l_counter).ADJUST_COMMENTS ,
575: 'MANUAL' ,
576: p_aia_rec_tbl(l_counter).SOURCE_DOC_ID ,

Line 582: decode(p_aia_rec_tbl(l_counter).ADJUST_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).ADJUST_DATE, 'dd/mm/yyyy hh24:mi:ss')),

578: p_aia_rec_tbl(l_counter).SALES_CHANNEL ,
579: p_aia_rec_tbl(l_counter).LINE_NUMBER ,
580: p_aia_rec_tbl(l_counter).REASON_CODE ,
581: p_aia_rec_tbl(l_counter).ATTRIBUTE_CATEGORY ,
582: decode(p_aia_rec_tbl(l_counter).ADJUST_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).ADJUST_DATE, 'dd/mm/yyyy hh24:mi:ss')),
583: p_aia_rec_tbl(l_counter).ADJUSTED_BY ,
584: p_aia_rec_tbl(l_counter).BILL_TO_ADDRESS_ID ,
585: p_aia_rec_tbl(l_counter).SHIP_TO_ADDRESS_ID ,
586: p_aia_rec_tbl(l_counter).BILL_TO_CONTACT_ID ,

Line 701: IF fnd_api.to_boolean

697: p_aia_rec_tbl(l_counter).ATTRIBUTE99 ,
698: p_aia_rec_tbl(l_counter).ATTRIBUTE100
699: );
700:
701: IF fnd_api.to_boolean
702: (
703: p_commit
704: )
705: THEN

Line 753: INVOICE_DATE =decode(p_aia_rec_tbl(l_counter).INVOICE_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).INVOICE_DATE, 'dd/mm/yyyy hh24:mi:ss')),

749: UPDATE CN_COLLECTION_AIA
750: SET SALESREP_ID =l_salesrep_id ,
751: EMPLOYEE_NUMBER =l_employee_number ,
752: PROCESSED_DATE =to_date(p_aia_rec_tbl(l_counter).PROCESSED_DATE, 'dd/mm/yyyy hh24:mi:ss'),
753: INVOICE_DATE =decode(p_aia_rec_tbl(l_counter).INVOICE_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).INVOICE_DATE, 'dd/mm/yyyy hh24:mi:ss')),
754: TRANSACTION_AMOUNT =p_aia_rec_tbl(l_counter).TRANSACTION_AMOUNT ,
755: TRANSACTION_CURRENCY_CODE =p_aia_rec_tbl(l_counter).TRANSACTION_CURRENCY_CODE ,
756: TRX_TYPE ='AIA_OM' ,
757: REVENUE_TYPE =decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE',

Line 757: REVENUE_TYPE =decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE',

753: INVOICE_DATE =decode(p_aia_rec_tbl(l_counter).INVOICE_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).INVOICE_DATE, 'dd/mm/yyyy hh24:mi:ss')),
754: TRANSACTION_AMOUNT =p_aia_rec_tbl(l_counter).TRANSACTION_AMOUNT ,
755: TRANSACTION_CURRENCY_CODE =p_aia_rec_tbl(l_counter).TRANSACTION_CURRENCY_CODE ,
756: TRX_TYPE ='AIA_OM' ,
757: REVENUE_TYPE =decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE',
758: p_aia_rec_tbl(l_counter).REVENUE_TYPE) ,
759: SALESREP_NUMBER =l_salesrep_number ,
760: ADJUST_COMMENTS =p_aia_rec_tbl(l_counter).ADJUST_COMMENTS ,
761: ADJUST_STATUS ='MANUAL' ,

Line 768: ADJUST_DATE =decode(p_aia_rec_tbl(l_counter).ADJUST_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).ADJUST_DATE, 'dd/mm/yyyy hh24:mi:ss')),

764: SALES_CHANNEL =p_aia_rec_tbl(l_counter).SALES_CHANNEL ,
765: LINE_NUMBER =p_aia_rec_tbl(l_counter).LINE_NUMBER ,
766: REASON_CODE =p_aia_rec_tbl(l_counter).REASON_CODE ,
767: ATTRIBUTE_CATEGORY =p_aia_rec_tbl(l_counter).ATTRIBUTE_CATEGORY ,
768: ADJUST_DATE =decode(p_aia_rec_tbl(l_counter).ADJUST_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).ADJUST_DATE, 'dd/mm/yyyy hh24:mi:ss')),
769: ADJUSTED_BY =p_aia_rec_tbl(l_counter).ADJUSTED_BY ,
770: BILL_TO_ADDRESS_ID =p_aia_rec_tbl(l_counter).BILL_TO_ADDRESS_ID ,
771: SHIP_TO_ADDRESS_ID =p_aia_rec_tbl(l_counter).SHIP_TO_ADDRESS_ID ,
772: BILL_TO_CONTACT_ID =p_aia_rec_tbl(l_counter).BILL_TO_CONTACT_ID ,

Line 887: IF fnd_api.to_boolean(p_commit) THEN

883: ATTRIBUTE99 =p_aia_rec_tbl(l_counter).ATTRIBUTE99 ,
884: ATTRIBUTE100 =p_aia_rec_tbl(l_counter).ATTRIBUTE100
885: WHERE ORDER_NUMBER = p_aia_rec_tbl(l_counter).ORDER_NUMBER;
886:
887: IF fnd_api.to_boolean(p_commit) THEN
888: COMMIT;
889: END IF;
890:
891: x_msg_count := 1;

Line 926: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)

922: --
923: --+
924: -- Parameters :
925: -- IN : p_api_version NUMBER Require
926: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
927: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
928: --
929: -- OUT : x_return_status VARCHAR2(1)
930: -- x_msg_count NUMBER

Line 927: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)

923: --+
924: -- Parameters :
925: -- IN : p_api_version NUMBER Require
926: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
927: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
928: --
929: -- OUT : x_return_status VARCHAR2(1)
930: -- x_msg_count NUMBER
931: -- x_msg_data VARCHAR2(2000)

Line 946: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

942: -- End of comments
943: PROCEDURE loadrow
944: (
945: p_api_version IN NUMBER,
946: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
947: p_commit IN VARCHAR2:= FND_API.G_FALSE,
948: p_aia_rec_tbl IN CN_COLLECTION_AIA_PUB.aia_rec_tbl_type,
949: p_org_id IN NUMBER,
950: p_aia_error_rec_tbl OUT nocopy CN_COLLECTION_AIA_PUB.aia_error_rec_tbl_type,

Line 947: p_commit IN VARCHAR2:= FND_API.G_FALSE,

943: PROCEDURE loadrow
944: (
945: p_api_version IN NUMBER,
946: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
947: p_commit IN VARCHAR2:= FND_API.G_FALSE,
948: p_aia_rec_tbl IN CN_COLLECTION_AIA_PUB.aia_rec_tbl_type,
949: p_org_id IN NUMBER,
950: p_aia_error_rec_tbl OUT nocopy CN_COLLECTION_AIA_PUB.aia_error_rec_tbl_type,
951: x_msg_count OUT nocopy NUMBER,

Line 1038: x_return_status := FND_API.G_RET_STS_SUCCESS;

1034: debugmsg('CN_COLLECTION_AIA_PUB.loadrow api:p_org_id: ' || p_org_id);
1035: debugmsg('CN_COLLECTION_AIA_PUB.loadrow api: p_api_version: ' || p_api_version);
1036:
1037: -- Initialize API return status to success
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;
1039:
1040: -- Standard call to check for call compatibility.
1041: /*IF NOT FND_API.Compatible_API_Call ( l_api_version , p_api_version , l_api_name , G_PKG_NAME ) THEN
1042: x_return_status := 'F';

Line 1041: /*IF NOT FND_API.Compatible_API_Call ( l_api_version , p_api_version , l_api_name , G_PKG_NAME ) THEN

1037: -- Initialize API return status to success
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;
1039:
1040: -- Standard call to check for call compatibility.
1041: /*IF NOT FND_API.Compatible_API_Call ( l_api_version , p_api_version , l_api_name , G_PKG_NAME ) THEN
1042: x_return_status := 'F';
1043: x_msg_count := 1;
1044: l_error_msg := 'p_api_version' || g_error_msg;
1045: debugmsg('CN_COLLECTION_AIA_PUB.loadrow api: l_error_msg: ' || l_error_msg);

Line 1065: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1061: --DBMS_OUTPUT.put_line('p_org_id ' || p_org_id);
1062: mo_global.set_policy_context('S',p_org_id);
1063:
1064: -- Initialize message list if p_init_msg_list is set to TRUE.
1065: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1066: FND_MSG_PUB.initialize;
1067: END IF;
1068:
1069: IF p_aia_rec_tbl.COUNT = 0

Line 1231: p_aia_rec_tbl(l_counter).PROCESSED_DATE = FND_API.G_MISS_CHAR) THEN

1227:
1228:
1229: --Mandatory fields validation starts here
1230: IF(p_aia_rec_tbl(l_counter).PROCESSED_DATE IS NULL or
1231: p_aia_rec_tbl(l_counter).PROCESSED_DATE = FND_API.G_MISS_CHAR) THEN
1232: x_return_status := 'F';
1233: x_msg_count := 1;
1234: l_tot_error_count := l_tot_error_count + 1;
1235: --l_error_msg := 'p_processed_date' || g_error_msg;

Line 1246: p_aia_rec_tbl(l_counter).INVOICE_NUMBER = FND_API.G_MISS_CHAR) THEN

1242: l_error_count := l_error_count + 1;
1243: END IF;
1244:
1245: IF(p_aia_rec_tbl(l_counter).INVOICE_NUMBER IS NULL or
1246: p_aia_rec_tbl(l_counter).INVOICE_NUMBER = FND_API.G_MISS_CHAR) THEN
1247: x_return_status := 'F';
1248: x_msg_count := 1;
1249: l_tot_error_count := l_tot_error_count + 1;
1250: --l_error_msg := 'p_invoice_number' || g_error_msg;

Line 1261: p_aia_rec_tbl(l_counter).INVOICE_DATE = FND_API.G_MISS_CHAR) THEN

1257: l_error_count := l_error_count +1;
1258: END IF;
1259:
1260: IF(p_aia_rec_tbl(l_counter).INVOICE_DATE IS NULL or
1261: p_aia_rec_tbl(l_counter).INVOICE_DATE = FND_API.G_MISS_CHAR) THEN
1262: x_return_status := 'F';
1263: x_msg_count := 1;
1264: l_tot_error_count := l_tot_error_count + 1;
1265: --l_error_msg := 'p_invoice_date' || g_error_msg;

Line 1291: AND p_aia_rec_tbl(l_counter).SALESREP_ID = G_LOC_MISS_NUM AND p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER = FND_API.G_MISS_CHAR) THEN

1287: l_error_count := l_error_count +1;
1288: END IF;
1289:
1290: IF(p_aia_rec_tbl(l_counter).SALESREP_ID IS NULL AND p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER IS NULL
1291: AND p_aia_rec_tbl(l_counter).SALESREP_ID = G_LOC_MISS_NUM AND p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER = FND_API.G_MISS_CHAR) THEN
1292: x_return_status := 'F';
1293: x_msg_count := 1;
1294: l_tot_error_count := l_tot_error_count + 1;
1295: --l_error_msg := 'Any one of p_salesrep_id or p_employee_number' || g_error_msg;

Line 1306: IF(p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER IS NOT NULL and p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER <> FND_API.G_MISS_CHAR) THEN

1302: END IF;
1303:
1304:
1305:
1306: IF(p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER IS NOT NULL and p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER <> FND_API.G_MISS_CHAR) THEN
1307: FOR l_resnum_srcnum_cr IN get_res_num_from_src_num(p_aia_rec_tbl(l_counter).EMPLOYEE_NUMBER)
1308: LOOP
1309: l_salesrep_number := l_resnum_srcnum_cr.employee_number;
1310: END LOOP;

Line 1508: decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE', p_aia_rec_tbl(l_counter).REVENUE_TYPE),

1504: to_date(p_aia_rec_tbl(l_counter).INVOICE_DATE, 'dd/mm/yyyy hh24:mi:ss'),
1505: p_aia_rec_tbl(l_counter).TRANSACTION_AMOUNT ,
1506: p_aia_rec_tbl(l_counter).TRANSACTION_CURRENCY_CODE ,
1507: 'AIA' ,
1508: decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE', p_aia_rec_tbl(l_counter).REVENUE_TYPE),
1509: l_salesrep_number ,
1510: p_aia_rec_tbl(l_counter).ADJUST_COMMENTS ,
1511: 'MANUAL' ,
1512: p_aia_rec_tbl(l_counter).SOURCE_DOC_ID ,

Line 1617: IF fnd_api.to_boolean

1613: p_aia_rec_tbl(l_counter).ATTRIBUTE99 ,
1614: p_aia_rec_tbl(l_counter).ATTRIBUTE100
1615: );
1616:
1617: IF fnd_api.to_boolean
1618: (
1619: p_commit
1620: )
1621: THEN

Line 1673: REVENUE_TYPE =decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE',

1669: INVOICE_DATE =to_date(p_aia_rec_tbl(l_counter).INVOICE_DATE, 'dd/mm/yyyy hh24:mi:ss'),
1670: TRANSACTION_AMOUNT =p_aia_rec_tbl(l_counter).TRANSACTION_AMOUNT ,
1671: TRANSACTION_CURRENCY_CODE =p_aia_rec_tbl(l_counter).TRANSACTION_CURRENCY_CODE ,
1672: TRX_TYPE ='AIA' ,
1673: REVENUE_TYPE =decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE',
1674: p_aia_rec_tbl(l_counter).REVENUE_TYPE) ,
1675: SALESREP_NUMBER =l_salesrep_number ,
1676: ADJUST_COMMENTS =p_aia_rec_tbl(l_counter).ADJUST_COMMENTS ,
1677: ADJUST_STATUS ='MANUAL' ,

Line 1783: IF fnd_api.to_boolean(p_commit) THEN

1779: ATTRIBUTE99 =p_aia_rec_tbl(l_counter).ATTRIBUTE99 ,
1780: ATTRIBUTE100 =p_aia_rec_tbl(l_counter).ATTRIBUTE100
1781: WHERE INVOICE_NUMBER = p_aia_rec_tbl(l_counter).INVOICE_NUMBER;
1782:
1783: IF fnd_api.to_boolean(p_commit) THEN
1784: COMMIT;
1785: END IF;
1786:
1787: x_msg_count := 1;