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.AR_ADJUST_PUB dependencies on AR_ADJUSTMENTS

Line 74: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,

70: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
71:
72: -- Added parameter p_llca_from_call for Line level Adjustment
73: PROCEDURE Validate_Adj_Insert (
74: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
75: p_chk_approval_limits IN varchar2,
76: p_check_amount IN varchar2,
77: p_validation_status IN OUT NOCOPY varchar2,
78: p_llca_from_call IN varchar2 DEFAULT 'N'

Line 464: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,

460: | |
461: +===========================================================================*/
462:
463: PROCEDURE Set_Remaining_Attributes (
464: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
465: p_return_status IN OUT NOCOPY varchar2
466: ) IS
467:
468: BEGIN

Line 557: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,

553: | id.
554: +===========================================================================*/
555:
556: PROCEDURE Validate_Adj_modify (
557: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
558: p_old_adj_rec IN ar_adjustments%rowtype,
559: p_chk_approval_limits IN varchar2,
560: p_validation_status IN OUT NOCOPY varchar2
561: ) IS

Line 558: p_old_adj_rec IN ar_adjustments%rowtype,

554: +===========================================================================*/
555:
556: PROCEDURE Validate_Adj_modify (
557: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
558: p_old_adj_rec IN ar_adjustments%rowtype,
559: p_chk_approval_limits IN varchar2,
560: p_validation_status IN OUT NOCOPY varchar2
561: ) IS
562:

Line 565: l_temp_adj_rec ar_adjustments%rowtype;

561: ) IS
562:
563: l_ps_rec ar_payment_schedules%rowtype;
564: l_approved_flag varchar2(1);
565: l_temp_adj_rec ar_adjustments%rowtype;
566: l_return_status varchar2(1);
567: l_cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE;
568:
569: BEGIN

Line 903: p_old_adj_rec IN ar_adjustments%rowtype,

899: | |
900: +===========================================================================*/
901:
902: PROCEDURE Validate_Adj_Reverse (
903: p_old_adj_rec IN ar_adjustments%rowtype,
904: p_reversal_gl_date IN OUT NOCOPY date,
905: p_reversal_date IN OUT NOCOPY date,
906: p_validation_status IN OUT NOCOPY varchar2
907: ) IS

Line 1047: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,

1043: | |
1044: +===========================================================================*/
1045:
1046: PROCEDURE Validate_Adj_Approve (
1047: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
1048: p_old_adj_rec IN ar_adjustments%rowtype,
1049: p_chk_approval_limits IN varchar2,
1050: p_validation_status IN OUT NOCOPY varchar2
1051: ) IS

Line 1048: p_old_adj_rec IN ar_adjustments%rowtype,

1044: +===========================================================================*/
1045:
1046: PROCEDURE Validate_Adj_Approve (
1047: p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
1048: p_old_adj_rec IN ar_adjustments%rowtype,
1049: p_chk_approval_limits IN varchar2,
1050: p_validation_status IN OUT NOCOPY varchar2
1051: ) IS
1052:

Line 1055: l_temp_adj_rec ar_adjustments%rowtype;

1051: ) IS
1052:
1053: l_ps_rec ar_payment_schedules%rowtype;
1054: l_approved_flag varchar2(1);
1055: l_temp_adj_rec ar_adjustments%rowtype;
1056: l_return_status varchar2(1);
1057:
1058: BEGIN
1059:

Line 1399: p_adj_rec IN ar_adjustments%rowtype,

1395: | |
1396: +===========================================================================*/
1397:
1398: PROCEDURE validate_hdr_level (
1399: p_adj_rec IN ar_adjustments%rowtype,
1400: p_return_status OUT NOCOPY VARCHAR2)
1401: IS
1402:
1403:

Line 1625: p_adj_rec IN ar_adjustments%rowtype,

1621: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1622: p_msg_count OUT NOCOPY number,
1623: p_msg_data OUT NOCOPY varchar2,
1624: p_return_status OUT NOCOPY varchar2 ,
1625: p_adj_rec IN ar_adjustments%rowtype,
1626: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
1627: p_check_amount IN varchar2 := FND_API.G_TRUE,
1628: p_move_deferred_tax IN varchar2,
1629: p_new_adjust_number OUT NOCOPY ar_adjustments.adjustment_number%type,

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

1625: p_adj_rec IN ar_adjustments%rowtype,
1626: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
1627: p_check_amount IN varchar2 := FND_API.G_TRUE,
1628: p_move_deferred_tax IN varchar2,
1629: p_new_adjust_number OUT NOCOPY ar_adjustments.adjustment_number%type,
1630: p_new_adjust_id OUT NOCOPY ar_adjustments.adjustment_id%type,
1631: p_called_from IN varchar2,
1632: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
1633: p_org_id IN NUMBER DEFAULT NULL

Line 1630: p_new_adjust_id OUT NOCOPY ar_adjustments.adjustment_id%type,

1626: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
1627: p_check_amount IN varchar2 := FND_API.G_TRUE,
1628: p_move_deferred_tax IN varchar2,
1629: p_new_adjust_number OUT NOCOPY ar_adjustments.adjustment_number%type,
1630: p_new_adjust_id OUT NOCOPY ar_adjustments.adjustment_id%type,
1631: p_called_from IN varchar2,
1632: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
1633: p_org_id IN NUMBER DEFAULT NULL
1634: ) IS

Line 1632: p_old_adjust_id IN ar_adjustments.adjustment_id%type,

1628: p_move_deferred_tax IN varchar2,
1629: p_new_adjust_number OUT NOCOPY ar_adjustments.adjustment_number%type,
1630: p_new_adjust_id OUT NOCOPY ar_adjustments.adjustment_id%type,
1631: p_called_from IN varchar2,
1632: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
1633: p_org_id IN NUMBER DEFAULT NULL
1634: ) IS
1635:
1636: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';

Line 1642: l_inp_adj_rec ar_adjustments%rowtype;

1638:
1639: l_hsec VARCHAR2(10);
1640: l_status number;
1641:
1642: l_inp_adj_rec ar_adjustments%rowtype;
1643: l_app_ps_rec ar_payment_schedules%rowtype;
1644:
1645: o_adjustment_number ar_adjustments.adjustment_number%type;
1646: o_adjustment_id ar_adjustments.adjustment_id%type;

Line 1645: o_adjustment_number ar_adjustments.adjustment_number%type;

1641:
1642: l_inp_adj_rec ar_adjustments%rowtype;
1643: l_app_ps_rec ar_payment_schedules%rowtype;
1644:
1645: o_adjustment_number ar_adjustments.adjustment_number%type;
1646: o_adjustment_id ar_adjustments.adjustment_id%type;
1647: l_return_status varchar2(1);
1648: l_chk_approval_limits varchar2(1);
1649: l_check_amount varchar2(1);

Line 1646: o_adjustment_id ar_adjustments.adjustment_id%type;

1642: l_inp_adj_rec ar_adjustments%rowtype;
1643: l_app_ps_rec ar_payment_schedules%rowtype;
1644:
1645: o_adjustment_number ar_adjustments.adjustment_number%type;
1646: o_adjustment_id ar_adjustments.adjustment_id%type;
1647: l_return_status varchar2(1);
1648: l_chk_approval_limits varchar2(1);
1649: l_check_amount varchar2(1);
1650:

Line 2127: p_adj_rec IN ar_adjustments%rowtype,

2123: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
2124: p_msg_count OUT NOCOPY number,
2125: p_msg_data OUT NOCOPY varchar2,
2126: p_return_status OUT NOCOPY varchar2 ,
2127: p_adj_rec IN ar_adjustments%rowtype,
2128: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
2129: p_llca_adj_trx_lines_tbl IN llca_adj_trx_line_tbl_type,
2130: p_check_amount IN varchar2 := FND_API.G_TRUE,
2131: p_move_deferred_tax IN varchar2,

Line 2134: p_old_adjust_id IN ar_adjustments.adjustment_id%type,

2130: p_check_amount IN varchar2 := FND_API.G_TRUE,
2131: p_move_deferred_tax IN varchar2,
2132: p_llca_adj_create_tbl_type OUT NOCOPY llca_adj_create_tbl_type,
2133: p_called_from IN varchar2,
2134: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
2135: p_org_id IN NUMBER DEFAULT NULL
2136: ) IS
2137:
2138: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';

Line 2144: l_inp_adj_rec ar_adjustments%rowtype;

2140:
2141: l_hsec VARCHAR2(10);
2142: l_status number;
2143:
2144: l_inp_adj_rec ar_adjustments%rowtype;
2145: l_app_ps_rec ar_payment_schedules%rowtype;
2146:
2147: o_adjustment_number ar_adjustments.adjustment_number%type;
2148: o_adjustment_id ar_adjustments.adjustment_id%type;

Line 2147: o_adjustment_number ar_adjustments.adjustment_number%type;

2143:
2144: l_inp_adj_rec ar_adjustments%rowtype;
2145: l_app_ps_rec ar_payment_schedules%rowtype;
2146:
2147: o_adjustment_number ar_adjustments.adjustment_number%type;
2148: o_adjustment_id ar_adjustments.adjustment_id%type;
2149: l_return_status varchar2(1);
2150: l_gt_return_status varchar2(1);
2151: l_hdr_return_status varchar2(1);

Line 2148: o_adjustment_id ar_adjustments.adjustment_id%type;

2144: l_inp_adj_rec ar_adjustments%rowtype;
2145: l_app_ps_rec ar_payment_schedules%rowtype;
2146:
2147: o_adjustment_number ar_adjustments.adjustment_number%type;
2148: o_adjustment_id ar_adjustments.adjustment_id%type;
2149: l_return_status varchar2(1);
2150: l_gt_return_status varchar2(1);
2151: l_hdr_return_status varchar2(1);
2152: l_line_return_status varchar2(1);

Line 2693: | ar_adjustments_pkg.fetch_p |

2689: | fnd_api.to_boolean |
2690: | fnd_msg_pub.check_msg_level |
2691: | fnd_msg_pub.count_and_get |
2692: | fnd_msg_pub.initialize |
2693: | ar_adjustments_pkg.fetch_p |
2694: | ar_process_adjustment.update_adjustment |
2695: | ar_adjvalidate_pvt.within_approval_limit |
2696: | |
2697: | ARGUMENTS : IN: |

Line 2742: p_adj_rec IN ar_adjustments%rowtype,

2738: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
2739: p_msg_count OUT NOCOPY number,
2740: p_msg_data OUT NOCOPY varchar2,
2741: p_return_status OUT NOCOPY varchar2 ,
2742: p_adj_rec IN ar_adjustments%rowtype,
2743: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
2744: p_move_deferred_tax IN varchar2,
2745: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
2746: p_org_id IN NUMBER DEFAULT NULL

Line 2745: p_old_adjust_id IN ar_adjustments.adjustment_id%type,

2741: p_return_status OUT NOCOPY varchar2 ,
2742: p_adj_rec IN ar_adjustments%rowtype,
2743: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
2744: p_move_deferred_tax IN varchar2,
2745: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
2746: p_org_id IN NUMBER DEFAULT NULL
2747: ) IS
2748:
2749: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';

Line 2751: l_old_adj_rec ar_adjustments%rowtype;

2747: ) IS
2748:
2749: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';
2750: l_api_version CONSTANT NUMBER := 1.0;
2751: l_old_adj_rec ar_adjustments%rowtype;
2752: l_hsec VARCHAR2(10);
2753: l_status number;
2754: l_inp_adj_rec ar_adjustments%rowtype;
2755: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2754: l_inp_adj_rec ar_adjustments%rowtype;

2750: l_api_version CONSTANT NUMBER := 1.0;
2751: l_old_adj_rec ar_adjustments%rowtype;
2752: l_hsec VARCHAR2(10);
2753: l_status number;
2754: l_inp_adj_rec ar_adjustments%rowtype;
2755: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
2756: l_chk_approval_limits varchar2(1);
2757: l_org_return_status VARCHAR2(1);
2758: l_org_id NUMBER;

Line 3120: | ar_adjustments_pkg.fetch_p |

3116: | fnd_api.to_boolean |
3117: | fnd_msg_pub.check_msg_level |
3118: | fnd_msg_pub.count_and_get |
3119: | fnd_msg_pub.initialize |
3120: | ar_adjustments_pkg.fetch_p |
3121: | ar_process_adjustment.reverse_adjustment |
3122: | |
3123: | ARGUMENTS : IN: |
3124: | p_api_name |

Line 3169: p_old_adjust_id IN ar_adjustments.adjustment_id%type,

3165: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
3166: p_msg_count OUT NOCOPY number,
3167: p_msg_data OUT NOCOPY varchar2,
3168: p_return_status OUT NOCOPY varchar2,
3169: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
3170: p_reversal_gl_date IN date,
3171: p_reversal_date IN date,
3172: p_comments IN ar_adjustments.comments%type,
3173: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,

Line 3172: p_comments IN ar_adjustments.comments%type,

3168: p_return_status OUT NOCOPY varchar2,
3169: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
3170: p_reversal_gl_date IN date,
3171: p_reversal_date IN date,
3172: p_comments IN ar_adjustments.comments%type,
3173: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
3174: p_move_deferred_tax IN varchar2,
3175: p_new_adj_id OUT NOCOPY ar_adjustments.adjustment_id%type,
3176: p_called_from IN varchar2,

Line 3175: p_new_adj_id OUT NOCOPY ar_adjustments.adjustment_id%type,

3171: p_reversal_date IN date,
3172: p_comments IN ar_adjustments.comments%type,
3173: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
3174: p_move_deferred_tax IN varchar2,
3175: p_new_adj_id OUT NOCOPY ar_adjustments.adjustment_id%type,
3176: p_called_from IN varchar2,
3177: p_org_id IN NUMBER DEFAULT NULL
3178: ) IS
3179:

Line 3183: l_reversal_date ar_adjustments.apply_date%type;

3179:
3180: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';
3181: l_api_version CONSTANT NUMBER := 1.0;
3182:
3183: l_reversal_date ar_adjustments.apply_date%type;
3184: l_reversal_gl_date ar_adjustments.gl_date%type;
3185: l_hsec VARCHAR2(10);
3186: l_status number;
3187: l_adj_rec ar_adjustments%rowtype;

Line 3184: l_reversal_gl_date ar_adjustments.gl_date%type;

3180: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';
3181: l_api_version CONSTANT NUMBER := 1.0;
3182:
3183: l_reversal_date ar_adjustments.apply_date%type;
3184: l_reversal_gl_date ar_adjustments.gl_date%type;
3185: l_hsec VARCHAR2(10);
3186: l_status number;
3187: l_adj_rec ar_adjustments%rowtype;
3188: l_msg_count number;

Line 3187: l_adj_rec ar_adjustments%rowtype;

3183: l_reversal_date ar_adjustments.apply_date%type;
3184: l_reversal_gl_date ar_adjustments.gl_date%type;
3185: l_hsec VARCHAR2(10);
3186: l_status number;
3187: l_adj_rec ar_adjustments%rowtype;
3188: l_msg_count number;
3189: l_msg_data varchar2(250);
3190: l_new_adj_num ar_adjustments.adjustment_number%type;
3191: l_check_amount varchar2(1);

Line 3190: l_new_adj_num ar_adjustments.adjustment_number%type;

3186: l_status number;
3187: l_adj_rec ar_adjustments%rowtype;
3188: l_msg_count number;
3189: l_msg_data varchar2(250);
3190: l_new_adj_num ar_adjustments.adjustment_number%type;
3191: l_check_amount varchar2(1);
3192:
3193: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
3194: l_chk_approval_limits varchar2(1);

Line 3698: | ar_adjustments_pkg.fetch_p |

3694: | fnd_api.to_boolean |
3695: | fnd_msg_pub.check_msg_level |
3696: | fnd_msg_pub.count_and_get |
3697: | fnd_msg_pub.initialize |
3698: | ar_adjustments_pkg.fetch_p |
3699: | ar_process_adjustment.update_approve_adjustment |
3700: | |
3701: | ARGUMENTS : IN: |
3702: | p_api_name |

Line 3748: p_adj_rec IN ar_adjustments%rowtype,

3744: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
3745: p_msg_count OUT NOCOPY number,
3746: p_msg_data OUT NOCOPY varchar2,
3747: p_return_status OUT NOCOPY varchar2 ,
3748: p_adj_rec IN ar_adjustments%rowtype,
3749: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
3750: p_move_deferred_tax IN varchar2,
3751: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
3752: p_org_id IN NUMBER DEFAULT NULL

Line 3751: p_old_adjust_id IN ar_adjustments.adjustment_id%type,

3747: p_return_status OUT NOCOPY varchar2 ,
3748: p_adj_rec IN ar_adjustments%rowtype,
3749: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
3750: p_move_deferred_tax IN varchar2,
3751: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
3752: p_org_id IN NUMBER DEFAULT NULL
3753: ) IS
3754:
3755: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';

Line 3757: l_old_adj_rec ar_adjustments%rowtype;

3753: ) IS
3754:
3755: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';
3756: l_api_version CONSTANT NUMBER := 1.0;
3757: l_old_adj_rec ar_adjustments%rowtype;
3758:
3759: l_inp_adj_rec ar_adjustments%rowtype;
3760: l_hsec VARCHAR2(10);
3761: l_status number;

Line 3759: l_inp_adj_rec ar_adjustments%rowtype;

3755: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';
3756: l_api_version CONSTANT NUMBER := 1.0;
3757: l_old_adj_rec ar_adjustments%rowtype;
3758:
3759: l_inp_adj_rec ar_adjustments%rowtype;
3760: l_hsec VARCHAR2(10);
3761: l_status number;
3762:
3763: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;