DBA Data[Home] [Help]

APPS.AR_ADJUSTAPI_PUB dependencies on AR_ADJUSTMENTS

Line 63: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,

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);

Line 266: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,

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

Line 347: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,

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:

Line 348: p_old_adj_rec IN ar_adjustments%rowtype,

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;

Line 354: l_temp_adj_rec ar_adjustments%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

Line 563: p_old_adj_rec IN ar_adjustments%rowtype,

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

Line 704: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,

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:

Line 705: p_old_adj_rec IN ar_adjustments%rowtype,

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;

Line 711: l_temp_adj_rec ar_adjustments%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

Line 958: p_adj_rec IN ar_adjustments%rowtype,

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:

Line 959: p_new_adjust_number OUT NOCOPY ar_adjustments.adjustment_number%type,

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';

Line 960: p_new_adjust_id OUT NOCOPY ar_adjustments.adjustment_id%type

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;

Line 969: l_inp_adj_rec ar_adjustments%rowtype;

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:

Line 970: o_adjustment_number ar_adjustments.adjustment_number%type;

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

Line 971: o_adjustment_id ar_adjustments.adjustment_id%type;

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

Line 1350: | ar_adjustments_pkg.fetch_p |

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: |

Line 1388: p_adj_rec IN ar_adjustments%rowtype,

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';

Line 1389: p_old_adjust_id IN ar_adjustments.adjustment_id%type

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;

Line 1394: l_old_adj_rec ar_adjustments%rowtype;

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;

Line 1397: l_inp_adj_rec ar_adjustments%rowtype;

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

Line 1763: | ar_adjustments_pkg.fetch_p |

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 |

Line 1799: p_old_adjust_id IN ar_adjustments.adjustment_id%type,

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:

Line 1807: l_reversal_date ar_adjustments.apply_date%type;

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;

Line 1808: l_reversal_gl_date ar_adjustments.gl_date%type;

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;

Line 1811: l_old_adj_rec ar_adjustments%rowtype;

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

Line 2183: | ar_adjustments_pkg.fetch_p |

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 |

Line 2220: p_adj_rec IN ar_adjustments%rowtype,

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';

Line 2221: p_old_adjust_id IN ar_adjustments.adjustment_id%type

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;

Line 2226: l_old_adj_rec ar_adjustments%rowtype;

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;

Line 2228: l_inp_adj_rec ar_adjustments%rowtype;

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;