APPS.AR_BILLS_MAINTAIN_LIB_PVT dependencies on AR_ADJUSTMENTS

Line 799: p_adj_id OUT NOCOPY ar_adjustments.adjustment_id%TYPE )

795: p_amount IN NUMBER ,
796: p_receivables_trx_id IN ar_receivables_trx.receivables_trx_id%TYPE ,
797: p_status IN VARCHAR2 ,
798: p_move_deferred_tax IN VARCHAR2 ,
799: p_adj_id OUT NOCOPY ar_adjustments.adjustment_id%TYPE )
800: IS
801:
802: adj_rec ar_adjustments%rowtype;
803: l_msg_count number :=0;

Line 802: adj_rec ar_adjustments%rowtype;

798: p_move_deferred_tax IN VARCHAR2 ,
799: p_adj_id OUT NOCOPY ar_adjustments.adjustment_id%TYPE )
800: IS
801:
802: adj_rec ar_adjustments%rowtype;
803: l_msg_count number :=0;
804: l_msg_data varchar2(2000);
805: l_return_status varchar2(1);
806: new_adj_num ar_adjustments.adjustment_number%type;

Line 806: new_adj_num ar_adjustments.adjustment_number%type;

802: adj_rec ar_adjustments%rowtype;
803: l_msg_count number :=0;
804: l_msg_data varchar2(2000);
805: l_return_status varchar2(1);
806: new_adj_num ar_adjustments.adjustment_number%type;
807: l_app_short_name varchar2(30);
808: l_message_name varchar2(30);
809: l_org_return_status VARCHAR2(1);
810: l_org_id NUMBER;

Line 933: p_adj_id OUT NOCOPY ar_adjustments.adjustment_id%TYPE )

929: +==============================================================================*/
930:
931:
932: PROCEDURE Find_Last_Adjustment (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
933: p_adj_id OUT NOCOPY ar_adjustments.adjustment_id%TYPE )
934:
935: IS
936:
937: BEGIN

Line 945: FROM ar_adjustments

941: END IF;
942:
943: SELECT max(adjustment_id)
944: INTO p_adj_id
945: FROM ar_adjustments
946: WHERE customer_trx_id = p_customer_trx_id;
947:
948: IF PG_DEBUG in ('Y', 'C') THEN
949: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment ()-');

Line 979: PROCEDURE Approve_Adjustment ( p_adj_id IN ar_adjustments.adjustment_id%TYPE,

975: | |
976: +==============================================================================*/
977:
978:
979: PROCEDURE Approve_Adjustment ( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
980: p_move_deferred_tax IN VARCHAR2 )
981: IS
982:
983:

Line 987: l_adj_rec AR_ADJUSTMENTS%ROWTYPE ;

983:
984: l_msg_data VARCHAR2(2000) ;
985: l_msg_count NUMBER ;
986: l_return_status VARCHAR2(1) ;
987: l_adj_rec AR_ADJUSTMENTS%ROWTYPE ;
988:
989: l_org_return_status VARCHAR2(1);
990: l_org_id NUMBER;
991:

Line 1001: from ar_adjustments

997:
998: /* SSA change */
999: select org_id
1000: into l_org_id
1001: from ar_adjustments
1002: where adjustment_id = p_adj_id;
1003: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
1004: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
1005: p_return_status =>l_org_return_status);

Line 1084: PROCEDURE Modify_Adjustment ( p_adj_id IN AR_ADJUSTMENTS.adjustment_id%TYPE,

1080: | |
1081: +==============================================================================*/
1082:
1083:
1084: PROCEDURE Modify_Adjustment ( p_adj_id IN AR_ADJUSTMENTS.adjustment_id%TYPE,
1085: p_status IN AR_ADJUSTMENTS.status%TYPE )
1086: IS
1087:
1088:

Line 1085: p_status IN AR_ADJUSTMENTS.status%TYPE )

1081: +==============================================================================*/
1082:
1083:
1084: PROCEDURE Modify_Adjustment ( p_adj_id IN AR_ADJUSTMENTS.adjustment_id%TYPE,
1085: p_status IN AR_ADJUSTMENTS.status%TYPE )
1086: IS
1087:
1088:
1089: l_msg_data VARCHAR2(2000) ;

Line 1092: l_adj_rec ar_adjustments%ROWTYPE ;

1088:
1089: l_msg_data VARCHAR2(2000) ;
1090: l_msg_count NUMBER ;
1091: l_return_status VARCHAR2(1) ;
1092: l_adj_rec ar_adjustments%ROWTYPE ;
1093: l_org_return_status VARCHAR2(1);
1094: l_org_id NUMBER;
1095:
1096: BEGIN

Line 1105: from ar_adjustments

1101:
1102: /* SSA change */
1103: select org_id
1104: into l_org_id
1105: from ar_adjustments
1106: where adjustment_id = p_adj_id;
1107: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
1108: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
1109: p_return_status =>l_org_return_status);

Line 1190: PROCEDURE Reverse_Adjustment ( p_adj_id IN ar_adjustments.adjustment_id%TYPE ,

1186: | |
1187: +==============================================================================*/
1188:
1189:
1190: PROCEDURE Reverse_Adjustment ( p_adj_id IN ar_adjustments.adjustment_id%TYPE ,
1191: p_trh_rec IN ar_transaction_history%ROWTYPE ,
1192: p_called_from IN VARCHAR2 )
1193: IS
1194:

Line 2051: l_adj_id ar_adjustments.adjustment_id%TYPE ;

2047: p_remittance_batch_id IN ra_customer_trx.remittance_batch_id%TYPE,
2048: p_unpaid_reason IN VARCHAR2 )
2049: IS
2050:
2051: l_adj_id ar_adjustments.adjustment_id%TYPE ;
2052: l_batch_rec ar_batches%ROWTYPE ;
2053: l_called_from VARCHAR2(30) := NULL ;
2054: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE ;
2055: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;