DBA Data[Home] [Help]

APPS.PA_PAY_INTERFACE dependencies on PA_TRANSACTIONS

Line 3928: pa_transactions.InsertExpGroup (

3924:
3925: IF l_burden_exists = 'Y' THEN
3926: -- If burden exists, create a expenditure group
3927: l_exp_group := 'PA-PAY-BURDEN-' || G_INTERFACE_RUN_ID || '-' || G_PERSON_ID;
3928: pa_transactions.InsertExpGroup (
3929: l_exp_group,
3930: 'RELEASED',
3931: G_PAY_PERIOD_END,
3932: 'BTC',

Line 3955: pa_transactions.InsertExp(

3951: into l_expenditure_id from dual;
3952:
3953: write_log(LOG,'Calling InsertExp' );
3954:
3955: pa_transactions.InsertExp(
3956: x_expenditure_id =>l_expenditure_id,
3957: x_expend_status =>'APPROVED',
3958: x_expend_ending => pa_utils.NewGetWeekEnding((G_PAY_PERIOD_END)), --Bug 2236707,3551106
3959: x_expend_class => 'BT',

Line 4040: pa_transactions_pub.validate_transaction(

4036:
4037: --Validate
4038: write_log(LOG,'Calling Validate transaction for ' || Y.project_id || '-'|| Y.task_id|| '-'||Y.expenditure_type );
4039:
4040: pa_transactions_pub.validate_transaction(
4041: x_project_id => Y.project_id,
4042: x_task_id => Y.task_id,
4043: x_ei_date => Y.expenditure_item_date,
4044: x_expenditure_type => Y.expenditure_type,

Line 4144: pa_transactions.LoadEi(

4140: END IF;
4141:
4142:
4143: /*
4144: pa_transactions.LoadEi(
4145: x_expenditure_item_id =>l_exp_item_id,
4146: x_expenditure_id =>l_expenditure_id,
4147: x_expenditure_item_date =>Y.expenditure_item_date ,
4148: x_project_id => Y.project_id,

Line 4327: -- pa_transactions.InsItems(1,0,'BTC','BTC',i, l_status,'N');

4323:
4324: write_log(LOG,'Burden expenditure Item created' || l_exp_item_id);
4325:
4326: END LOOP; -- End Y loop .. Exp Items
4327: -- pa_transactions.InsItems(1,0,'BTC','BTC',i, l_status,'N');
4328:
4329: /* UPDATE pa_expenditure_items_all
4330: SET interface_run_id = G_INTERFACE_RUN_ID
4331: ,COSTING_METHOD = 'ACTUAL'

Line 4339: -- pa_transactions.FlushEiTabs;

4335: -- write_log(LOG,'Expenditure Items Created -' || i || ' burden amounts processed ');
4336:
4337:
4338: -- write_log(LOG,'After InsItems' );
4339: -- pa_transactions.FlushEiTabs;
4340:
4341:
4342: END LOOP; -- X Loop Expenditures
4343:

Line 4404: pa_transactions.InsertExpGroup (

4400:
4401: -- If PJ exists, create a expenditure group
4402:
4403: l_exp_group := 'PA-PAY-MISC-' || G_INTERFACE_RUN_ID || '-' || G_PERSON_ID;
4404: pa_transactions.InsertExpGroup (
4405: l_exp_group,
4406: 'RELEASED',
4407: G_PAY_PERIOD_END,
4408: 'PJ',

Line 4437: pa_transactions.InsertExp(

4433: into l_expenditure_id from dual;
4434:
4435: write_log(LOG,'Calling InsertExp for ' || X.organization_id || ' - ' || x.denom_currency_code );
4436:
4437: pa_transactions.InsertExp(
4438: x_expenditure_id =>l_expenditure_id,
4439: x_expend_status =>'APPROVED',
4440: x_expend_ending => pa_utils.NewGetWeekEnding((G_PAY_PERIOD_END)), --Bug 2236707,3551106
4441: x_expend_class => 'PU',

Line 4525: pa_transactions_pub.validate_transaction(

4521:
4522:
4523: --Validate
4524:
4525: pa_transactions_pub.validate_transaction(
4526: x_project_id => Y.project_id,
4527: x_task_id => Y.task_id,
4528: x_ei_date => Y.expenditure_item_date,
4529: x_expenditure_type => Y.expenditure_type,

Line 4628: pa_transactions.LoadEi(

4624:
4625: END IF;
4626: /*
4627:
4628: pa_transactions.LoadEi(
4629: x_expenditure_item_id =>l_exp_item_id,
4630: x_expenditure_id =>l_expenditure_id,
4631: x_expenditure_item_date =>Y.expenditure_item_date ,
4632: x_project_id => Y.project_id,

Line 4819: /* -- pa_transactions.InsItems(1,0,'PJ','PJ',i, l_status,'N');

4815: -- write_log(LOG,'After Load Ei' );
4816:
4817:
4818: END LOOP; -- End Y loop .. Exp Items
4819: /* -- pa_transactions.InsItems(1,0,'PJ','PJ',i, l_status,'N');
4820:
4821: UPDATE pa_expenditure_items_all
4822: SET interface_run_id = G_INTERFACE_RUN_ID
4823: ,COSTING_METHOD = 'ACTUAL'

Line 4829: -- pa_transactions.FlushEiTabs;

4825: WHERE expenditure_id = l_expenditure_id ;
4826:
4827: write_log(LOG,'After InsItems' );
4828:
4829: -- pa_transactions.FlushEiTabs;
4830:
4831: write_log(LOG,'Expenditure Items Created -' || i || ' Misc amounts processed '); */
4832: END LOOP; -- X Loop Expenditures
4833:

Line 5533: pa_transactions.InsItemComment

5529: NULL;
5530: END;
5531:
5532: IF ( l_item_comment IS NOT NULL ) THEN
5533: pa_transactions.InsItemComment
5534: ( X_ei_id => l_transfer_id ,
5535: X_ei_comment => l_item_comment ,
5536: X_user => G_USER_ID ,
5537: X_login => G_LOGIN_ID ,