59: +===========================================================================*/
60:
61:
62: PROCEDURE Validate_Adj_Insert (
63: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
64: p_validation_status IN OUT NOCOPY varchar2
65: ) IS
66:
67: l_return_status varchar2(1);
262: | |
263: +===========================================================================*/
264:
265: PROCEDURE Set_Remaining_Attributes (
266: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
267: p_return_status IN OUT NOCOPY varchar2
268: ) IS
269:
270: BEGIN
343: | |
344: +===========================================================================*/
345:
346: PROCEDURE Validate_Adj_modify (
347: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
348: p_old_adj_rec IN ar_adjustments%rowtype,
349: p_validation_status IN OUT NOCOPY varchar2
350: ) IS
351:
344: +===========================================================================*/
345:
346: PROCEDURE Validate_Adj_modify (
347: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
348: p_old_adj_rec IN ar_adjustments%rowtype,
349: p_validation_status IN OUT NOCOPY varchar2
350: ) IS
351:
352: l_ps_rec ar_payment_schedules%rowtype;
350: ) IS
351:
352: l_ps_rec ar_payment_schedules%rowtype;
353: l_approved_flag varchar2(1);
354: l_temp_adj_rec ar_adjustments%rowtype;
355:
356: BEGIN
357:
358: IF PG_DEBUG in ('Y', 'C') THEN
559: | |
560: +===========================================================================*/
561:
562: PROCEDURE Validate_Adj_Reverse (
563: p_old_adj_rec IN ar_adjustments%rowtype,
564: p_reversal_gl_date IN OUT NOCOPY date,
565: p_reversal_date IN OUT NOCOPY date,
566: p_validation_status IN OUT NOCOPY varchar2
567: ) IS
700: | |
701: +===========================================================================*/
702:
703: PROCEDURE Validate_Adj_Approve (
704: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
705: p_old_adj_rec IN ar_adjustments%rowtype,
706: p_validation_status IN OUT NOCOPY varchar2
707: ) IS
708:
701: +===========================================================================*/
702:
703: PROCEDURE Validate_Adj_Approve (
704: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
705: p_old_adj_rec IN ar_adjustments%rowtype,
706: p_validation_status IN OUT NOCOPY varchar2
707: ) IS
708:
709: l_ps_rec ar_payment_schedules%rowtype;
707: ) IS
708:
709: l_ps_rec ar_payment_schedules%rowtype;
710: l_approved_flag varchar2(1);
711: l_temp_adj_rec ar_adjustments%rowtype;
712:
713: BEGIN
714:
715: IF PG_DEBUG in ('Y', 'C') THEN
954: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
955: p_msg_count OUT NOCOPY number,
956: p_msg_data OUT NOCOPY varchar2,
957: p_return_status OUT NOCOPY varchar2 ,
958: p_adj_rec IN ar_adjustments%rowtype,
959: p_new_adjust_number OUT NOCOPY ar_adjustments.adjustment_number%type,
960: p_new_adjust_id OUT NOCOPY ar_adjustments.adjustment_id%type
961: ) IS
962:
955: p_msg_count OUT NOCOPY number,
956: p_msg_data OUT NOCOPY varchar2,
957: p_return_status OUT NOCOPY varchar2 ,
958: p_adj_rec IN ar_adjustments%rowtype,
959: p_new_adjust_number OUT NOCOPY ar_adjustments.adjustment_number%type,
960: p_new_adjust_id OUT NOCOPY ar_adjustments.adjustment_id%type
961: ) IS
962:
963: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
956: p_msg_data OUT NOCOPY varchar2,
957: p_return_status OUT NOCOPY varchar2 ,
958: p_adj_rec IN ar_adjustments%rowtype,
959: p_new_adjust_number OUT NOCOPY ar_adjustments.adjustment_number%type,
960: p_new_adjust_id OUT NOCOPY ar_adjustments.adjustment_id%type
961: ) IS
962:
963: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
964: l_api_version CONSTANT NUMBER := 1.0;
965:
966: l_hsec VARCHAR2(10);
967: l_status number;
968:
969: l_inp_adj_rec ar_adjustments%rowtype;
970: o_adjustment_number ar_adjustments.adjustment_number%type;
971: o_adjustment_id ar_adjustments.adjustment_id%type;
972: l_return_status varchar2(1);
973:
966: l_hsec VARCHAR2(10);
967: l_status number;
968:
969: l_inp_adj_rec ar_adjustments%rowtype;
970: o_adjustment_number ar_adjustments.adjustment_number%type;
971: o_adjustment_id ar_adjustments.adjustment_id%type;
972: l_return_status varchar2(1);
973:
974: BEGIN
967: l_status number;
968:
969: l_inp_adj_rec ar_adjustments%rowtype;
970: o_adjustment_number ar_adjustments.adjustment_number%type;
971: o_adjustment_id ar_adjustments.adjustment_id%type;
972: l_return_status varchar2(1);
973:
974: BEGIN
975: select hsecs
1346: | fnd_api.to_boolean |
1347: | fnd_msg_pub.check_msg_level |
1348: | fnd_msg_pub.count_and_get |
1349: | fnd_msg_pub.initialize |
1350: | ar_adjustments_pkg.fetch_p |
1351: | ar_process_adjustment.update_adjustment |
1352: | ar_adjvalidate_pub.within_approval_limit |
1353: | |
1354: | ARGUMENTS : IN: |
1384: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1385: p_msg_count OUT NOCOPY number,
1386: p_msg_data OUT NOCOPY varchar2,
1387: p_return_status OUT NOCOPY varchar2 ,
1388: p_adj_rec IN ar_adjustments%rowtype,
1389: p_old_adjust_id IN ar_adjustments.adjustment_id%type
1390: ) IS
1391:
1392: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
1385: p_msg_count OUT NOCOPY number,
1386: p_msg_data OUT NOCOPY varchar2,
1387: p_return_status OUT NOCOPY varchar2 ,
1388: p_adj_rec IN ar_adjustments%rowtype,
1389: p_old_adjust_id IN ar_adjustments.adjustment_id%type
1390: ) IS
1391:
1392: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
1393: l_api_version CONSTANT NUMBER := 1.0;
1390: ) IS
1391:
1392: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
1393: l_api_version CONSTANT NUMBER := 1.0;
1394: l_old_adj_rec ar_adjustments%rowtype;
1395: l_hsec VARCHAR2(10);
1396: l_status number;
1397: l_inp_adj_rec ar_adjustments%rowtype;
1398: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1393: l_api_version CONSTANT NUMBER := 1.0;
1394: l_old_adj_rec ar_adjustments%rowtype;
1395: l_hsec VARCHAR2(10);
1396: l_status number;
1397: l_inp_adj_rec ar_adjustments%rowtype;
1398: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1399:
1400:
1401: BEGIN
1759: | fnd_api.to_boolean |
1760: | fnd_msg_pub.check_msg_level |
1761: | fnd_msg_pub.count_and_get |
1762: | fnd_msg_pub.initialize |
1763: | ar_adjustments_pkg.fetch_p |
1764: | ar_process_adjustment.reverse_adjustment |
1765: | |
1766: | ARGUMENTS : IN: |
1767: | p_api_name |
1795: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1796: p_msg_count OUT NOCOPY number,
1797: p_msg_data OUT NOCOPY varchar2,
1798: p_return_status OUT NOCOPY varchar2 ,
1799: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
1800: p_reversal_gl_date IN date,
1801: p_reversal_date IN date
1802: ) IS
1803:
1803:
1804: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
1805: l_api_version CONSTANT NUMBER := 1.0;
1806:
1807: l_reversal_date ar_adjustments.apply_date%type;
1808: l_reversal_gl_date ar_adjustments.gl_date%type;
1809: l_hsec VARCHAR2(10);
1810: l_status number;
1811: l_old_adj_rec ar_adjustments%rowtype;
1804: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
1805: l_api_version CONSTANT NUMBER := 1.0;
1806:
1807: l_reversal_date ar_adjustments.apply_date%type;
1808: l_reversal_gl_date ar_adjustments.gl_date%type;
1809: l_hsec VARCHAR2(10);
1810: l_status number;
1811: l_old_adj_rec ar_adjustments%rowtype;
1812: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1807: l_reversal_date ar_adjustments.apply_date%type;
1808: l_reversal_gl_date ar_adjustments.gl_date%type;
1809: l_hsec VARCHAR2(10);
1810: l_status number;
1811: l_old_adj_rec ar_adjustments%rowtype;
1812: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1813:
1814:
1815: BEGIN
2179: | fnd_api.to_boolean |
2180: | fnd_msg_pub.check_msg_level |
2181: | fnd_msg_pub.count_and_get |
2182: | fnd_msg_pub.initialize |
2183: | ar_adjustments_pkg.fetch_p |
2184: | ar_process_adjustment.update_approve_adjustment |
2185: | |
2186: | ARGUMENTS : IN: |
2187: | p_api_name |
2216: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
2217: p_msg_count OUT NOCOPY number,
2218: p_msg_data OUT NOCOPY varchar2,
2219: p_return_status OUT NOCOPY varchar2 ,
2220: p_adj_rec IN ar_adjustments%rowtype,
2221: p_old_adjust_id IN ar_adjustments.adjustment_id%type
2222: ) IS
2223:
2224: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
2217: p_msg_count OUT NOCOPY number,
2218: p_msg_data OUT NOCOPY varchar2,
2219: p_return_status OUT NOCOPY varchar2 ,
2220: p_adj_rec IN ar_adjustments%rowtype,
2221: p_old_adjust_id IN ar_adjustments.adjustment_id%type
2222: ) IS
2223:
2224: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
2225: l_api_version CONSTANT NUMBER := 1.0;
2222: ) IS
2223:
2224: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
2225: l_api_version CONSTANT NUMBER := 1.0;
2226: l_old_adj_rec ar_adjustments%rowtype;
2227:
2228: l_inp_adj_rec ar_adjustments%rowtype;
2229: l_hsec VARCHAR2(10);
2230: l_status number;
2224: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
2225: l_api_version CONSTANT NUMBER := 1.0;
2226: l_old_adj_rec ar_adjustments%rowtype;
2227:
2228: l_inp_adj_rec ar_adjustments%rowtype;
2229: l_hsec VARCHAR2(10);
2230: l_status number;
2231:
2232: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;