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.PN_LEASE_PVT dependencies on FND_GLOBAL

Line 7: g_resp_appl_id CONSTANT NUMBER := fnd_global.resp_appl_id;

3:
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_LEASE_PVT';
5: g_table_name CONSTANT VARCHAR2 (40) := 'PN_LEASES_ALL';
6: g_tl_table_name CONSTANT VARCHAR2 (40) := 'NONE';
7: g_resp_appl_id CONSTANT NUMBER := fnd_global.resp_appl_id;
8: g_resp_id CONSTANT NUMBER := fnd_global.resp_id;
9: g_user_id CONSTANT NUMBER := fnd_global.user_id;
10: g_login_id CONSTANT NUMBER := fnd_global.login_id;
11: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');

Line 8: g_resp_id CONSTANT NUMBER := fnd_global.resp_id;

4: g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_LEASE_PVT';
5: g_table_name CONSTANT VARCHAR2 (40) := 'PN_LEASES_ALL';
6: g_tl_table_name CONSTANT VARCHAR2 (40) := 'NONE';
7: g_resp_appl_id CONSTANT NUMBER := fnd_global.resp_appl_id;
8: g_resp_id CONSTANT NUMBER := fnd_global.resp_id;
9: g_user_id CONSTANT NUMBER := fnd_global.user_id;
10: g_login_id CONSTANT NUMBER := fnd_global.login_id;
11: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');
12: -- Variables to hold the lookup_types

Line 9: g_user_id CONSTANT NUMBER := fnd_global.user_id;

5: g_table_name CONSTANT VARCHAR2 (40) := 'PN_LEASES_ALL';
6: g_tl_table_name CONSTANT VARCHAR2 (40) := 'NONE';
7: g_resp_appl_id CONSTANT NUMBER := fnd_global.resp_appl_id;
8: g_resp_id CONSTANT NUMBER := fnd_global.resp_id;
9: g_user_id CONSTANT NUMBER := fnd_global.user_id;
10: g_login_id CONSTANT NUMBER := fnd_global.login_id;
11: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');
12: -- Variables to hold the lookup_types
13: l_leasetype_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_TYPE';

Line 10: g_login_id CONSTANT NUMBER := fnd_global.login_id;

6: g_tl_table_name CONSTANT VARCHAR2 (40) := 'NONE';
7: g_resp_appl_id CONSTANT NUMBER := fnd_global.resp_appl_id;
8: g_resp_id CONSTANT NUMBER := fnd_global.resp_id;
9: g_user_id CONSTANT NUMBER := fnd_global.user_id;
10: g_login_id CONSTANT NUMBER := fnd_global.login_id;
11: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');
12: -- Variables to hold the lookup_types
13: l_leasetype_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_TYPE';
14: l_leaseclass_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_CLASS';

Line 1193: , p_resp_appl_id => fnd_global.resp_appl_id

1189: , p_desc_segment13 => p_lease_tenancies_tbl(i).attribute13
1190: , p_desc_segment14 => p_lease_tenancies_tbl(i).attribute14
1191: , p_desc_segment15 => p_lease_tenancies_tbl(i).attribute15
1192: , p_desc_context => p_lease_tenancies_tbl(i).attribute_category
1193: , p_resp_appl_id => fnd_global.resp_appl_id
1194: , p_resp_id => fnd_global.resp_id
1195: , p_return_status => x_return_status
1196: );
1197:

Line 1194: , p_resp_id => fnd_global.resp_id

1190: , p_desc_segment14 => p_lease_tenancies_tbl(i).attribute14
1191: , p_desc_segment15 => p_lease_tenancies_tbl(i).attribute15
1192: , p_desc_context => p_lease_tenancies_tbl(i).attribute_category
1193: , p_resp_appl_id => fnd_global.resp_appl_id
1194: , p_resp_id => fnd_global.resp_id
1195: , p_return_status => x_return_status
1196: );
1197:
1198: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 1396: , x_last_update_login => fnd_global.login_id

1392: , x_attribute14 => p_lease_tenancies_rec.attribute14
1393: , x_attribute15 => p_lease_tenancies_rec.attribute15
1394: , x_last_update_date => SYSDATE
1395: , x_last_updated_by => g_user_id
1396: , x_last_update_login => fnd_global.login_id
1397: , x_tenancy_ovelap_wrn => l_tenancy_ovelap_wrn
1398: , x_recovery_type_code => p_lease_tenancies_rec.recovery_type_code
1399: , x_recovery_space_std_code => p_lease_tenancies_rec.recovery_space_std_code
1400: , x_fin_oblig_end_date => p_lease_tenancies_rec.fin_oblig_end_date

Line 1434: , x_last_update_login => fnd_global.login_id

1430: pn_contact_assignments_pkg.update_row
1431: (x_contact_assignment_id => p_lease_contacts_rec.contact_assignment_id
1432: , x_last_update_date => SYSDATE
1433: , x_last_updated_by => g_user_id
1434: , x_last_update_login => fnd_global.login_id
1435: , x_company_id => p_lease_contacts_rec.company_id
1436: , x_company_site_id => p_lease_contacts_rec.company_site_id
1437: , x_lease_id => p_lease_contacts_rec.lease_id
1438: , x_lease_change_id => p_lease_contacts_rec.lease_change_id

Line 1858: , p_resp_appl_id => fnd_global.resp_appl_id

1854: , p_desc_segment13 => p_lease_tenancies_tbl_update (i).attribute13
1855: , p_desc_segment14 => p_lease_tenancies_tbl_update (i).attribute14
1856: , p_desc_segment15 => p_lease_tenancies_tbl_update (i).attribute15
1857: , p_desc_context => p_lease_tenancies_tbl_update (i).attribute_category
1858: , p_resp_appl_id => fnd_global.resp_appl_id
1859: , p_resp_id => fnd_global.resp_id
1860: , p_return_status => x_return_status
1861: );
1862:

Line 1859: , p_resp_id => fnd_global.resp_id

1855: , p_desc_segment14 => p_lease_tenancies_tbl_update (i).attribute14
1856: , p_desc_segment15 => p_lease_tenancies_tbl_update (i).attribute15
1857: , p_desc_context => p_lease_tenancies_tbl_update (i).attribute_category
1858: , p_resp_appl_id => fnd_global.resp_appl_id
1859: , p_resp_id => fnd_global.resp_id
1860: , p_return_status => x_return_status
1861: );
1862:
1863: IF (x_return_status = fnd_api.g_ret_sts_error)

Line 2224: , p_resp_appl_id => fnd_global.resp_appl_id

2220: , p_desc_segment13 => p_lease_contacts_tbl_update (i).attribute13
2221: , p_desc_segment14 => p_lease_contacts_tbl_update (i).attribute14
2222: , p_desc_segment15 => p_lease_contacts_tbl_update (i).attribute15
2223: , p_desc_context => p_lease_contacts_tbl_update (i).attribute_category
2224: , p_resp_appl_id => fnd_global.resp_appl_id
2225: ,p_resp_id => fnd_global.resp_id
2226: , p_return_status => x_return_status
2227: );
2228: IF (x_return_status = fnd_api.g_ret_sts_error)THEN

Line 2225: ,p_resp_id => fnd_global.resp_id

2221: , p_desc_segment14 => p_lease_contacts_tbl_update (i).attribute14
2222: , p_desc_segment15 => p_lease_contacts_tbl_update (i).attribute15
2223: , p_desc_context => p_lease_contacts_tbl_update (i).attribute_category
2224: , p_resp_appl_id => fnd_global.resp_appl_id
2225: ,p_resp_id => fnd_global.resp_id
2226: , p_return_status => x_return_status
2227: );
2228: IF (x_return_status = fnd_api.g_ret_sts_error)THEN
2229: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');

Line 2407: , x_last_updated_by => fnd_global.user_id

2403: , x_abstracted_by_user => p_abstracted_by_user
2404: , x_status => p_status
2405: , x_lease_status => p_lease_status
2406: , x_last_update_date => sysdate
2407: , x_last_updated_by => fnd_global.user_id
2408: , x_last_update_login => fnd_global.login_id
2409: , x_responsible_user => p_responsible_user
2410: , x_expense_account_id => p_expense_account_id
2411: , x_accrual_account_id => p_accrual_account_id

Line 2408: , x_last_update_login => fnd_global.login_id

2404: , x_status => p_status
2405: , x_lease_status => p_lease_status
2406: , x_last_update_date => sysdate
2407: , x_last_updated_by => fnd_global.user_id
2408: , x_last_update_login => fnd_global.login_id
2409: , x_responsible_user => p_responsible_user
2410: , x_expense_account_id => p_expense_account_id
2411: , x_accrual_account_id => p_accrual_account_id
2412: , x_receivable_account_id => p_receivable_account_id

Line 2551: , x_last_update_login => fnd_global.login_id

2547: , x_creation_date => l_creationdate
2548: , x_created_by => p_user_id
2549: , x_last_update_date => l_lastupdatedate
2550: , x_last_updated_by => p_user_id
2551: , x_last_update_login => fnd_global.login_id
2552: , x_org_id => l_org_id
2553: , x_cutoff_date => NULL);
2554: pvt_debug(g_pkg_name||'-AMEND_LEASE:Insertion into the table successful',3);
2555: x_lease_change_id := l_leasechangeid;

Line 2632: , x_created_by => fnd_global.user_id

2628: , x_attribute14 => NULL
2629: , x_attribute15 => NULL
2630: , x_abstracted_by_user => NULL
2631: , x_creation_date => l_creationdate
2632: , x_created_by => fnd_global.user_id
2633: , x_last_update_date => l_lastupdatedate
2634: , x_last_updated_by => fnd_global.user_id
2635: , x_last_update_login => fnd_global.login_id
2636: , x_org_id => l_org_id);

Line 2634: , x_last_updated_by => fnd_global.user_id

2630: , x_abstracted_by_user => NULL
2631: , x_creation_date => l_creationdate
2632: , x_created_by => fnd_global.user_id
2633: , x_last_update_date => l_lastupdatedate
2634: , x_last_updated_by => fnd_global.user_id
2635: , x_last_update_login => fnd_global.login_id
2636: , x_org_id => l_org_id);
2637: pvt_debug(g_pkg_name||'-EDIT_LEASE:Insertion into the table successful',3);
2638: x_return_status := fnd_api.g_ret_sts_success;

Line 2635: , x_last_update_login => fnd_global.login_id

2631: , x_creation_date => l_creationdate
2632: , x_created_by => fnd_global.user_id
2633: , x_last_update_date => l_lastupdatedate
2634: , x_last_updated_by => fnd_global.user_id
2635: , x_last_update_login => fnd_global.login_id
2636: , x_org_id => l_org_id);
2637: pvt_debug(g_pkg_name||'-EDIT_LEASE:Insertion into the table successful',3);
2638: x_return_status := fnd_api.g_ret_sts_success;
2639: x_lease_change_id := l_leasechangeid;

Line 3089: , x_created_by => NVL (p_lease_tenancies_rec.created_by, fnd_global.user_id)

3085: , x_attribute13 => p_lease_tenancies_rec.attribute13
3086: , x_attribute14 => p_lease_tenancies_rec.attribute14
3087: , x_attribute15 => p_lease_tenancies_rec.attribute15
3088: , x_creation_date => NVL (p_lease_tenancies_rec.creation_date, SYSDATE)
3089: , x_created_by => NVL (p_lease_tenancies_rec.created_by, fnd_global.user_id)
3090: , x_last_update_date => NVL (p_lease_tenancies_rec.last_update_date, SYSDATE)
3091: , x_last_updated_by => NVL (p_lease_tenancies_rec.last_updated_by, fnd_global.user_id)
3092: , x_last_update_login => NVL (p_lease_tenancies_rec.last_update_login, fnd_global.login_id)
3093: , x_org_id => p_lease_tenancies_rec.org_id

Line 3091: , x_last_updated_by => NVL (p_lease_tenancies_rec.last_updated_by, fnd_global.user_id)

3087: , x_attribute15 => p_lease_tenancies_rec.attribute15
3088: , x_creation_date => NVL (p_lease_tenancies_rec.creation_date, SYSDATE)
3089: , x_created_by => NVL (p_lease_tenancies_rec.created_by, fnd_global.user_id)
3090: , x_last_update_date => NVL (p_lease_tenancies_rec.last_update_date, SYSDATE)
3091: , x_last_updated_by => NVL (p_lease_tenancies_rec.last_updated_by, fnd_global.user_id)
3092: , x_last_update_login => NVL (p_lease_tenancies_rec.last_update_login, fnd_global.login_id)
3093: , x_org_id => p_lease_tenancies_rec.org_id
3094: , x_tenancy_ovelap_wrn => x_tenancy_ovelap_wrn
3095: , x_recovery_type_code => p_lease_tenancies_rec.recovery_type_code

Line 3092: , x_last_update_login => NVL (p_lease_tenancies_rec.last_update_login, fnd_global.login_id)

3088: , x_creation_date => NVL (p_lease_tenancies_rec.creation_date, SYSDATE)
3089: , x_created_by => NVL (p_lease_tenancies_rec.created_by, fnd_global.user_id)
3090: , x_last_update_date => NVL (p_lease_tenancies_rec.last_update_date, SYSDATE)
3091: , x_last_updated_by => NVL (p_lease_tenancies_rec.last_updated_by, fnd_global.user_id)
3092: , x_last_update_login => NVL (p_lease_tenancies_rec.last_update_login, fnd_global.login_id)
3093: , x_org_id => p_lease_tenancies_rec.org_id
3094: , x_tenancy_ovelap_wrn => x_tenancy_ovelap_wrn
3095: , x_recovery_type_code => p_lease_tenancies_rec.recovery_type_code
3096: , x_recovery_space_std_code => p_lease_tenancies_rec.recovery_space_std_code

Line 3315: , fnd_global.user_id)

3311: (p_lease_contacts_rec.last_update_date
3312: , SYSDATE)
3313: , x_last_updated_by => NVL
3314: (p_lease_contacts_rec.last_updated_by
3315: , fnd_global.user_id)
3316: , x_creation_date => NVL
3317: (p_lease_contacts_rec.creation_date
3318: , SYSDATE)
3319: , x_created_by => NVL (p_lease_contacts_rec.created_by

Line 3320: , fnd_global.user_id)

3316: , x_creation_date => NVL
3317: (p_lease_contacts_rec.creation_date
3318: , SYSDATE)
3319: , x_created_by => NVL (p_lease_contacts_rec.created_by
3320: , fnd_global.user_id)
3321: , x_last_update_login => NVL
3322: (p_lease_contacts_rec.last_update_login
3323: , fnd_global.login_id)
3324: , x_company_id => p_lease_contacts_rec.company_id

Line 3323: , fnd_global.login_id)

3319: , x_created_by => NVL (p_lease_contacts_rec.created_by
3320: , fnd_global.user_id)
3321: , x_last_update_login => NVL
3322: (p_lease_contacts_rec.last_update_login
3323: , fnd_global.login_id)
3324: , x_company_id => p_lease_contacts_rec.company_id
3325: , x_company_site_id => p_lease_contacts_rec.company_site_id
3326: , x_lease_id => p_lease_contacts_rec.lease_id
3327: , x_lease_change_id => p_lease_contacts_rec.lease_change_id

Line 3770: , p_resp_appl_id => fnd_global.resp_appl_id

3766: , p_desc_segment13 => p_lease_contacts_tbl(i).attribute13
3767: , p_desc_segment14 => p_lease_contacts_tbl(i).attribute14
3768: , p_desc_segment15 => p_lease_contacts_tbl(i).attribute15
3769: , p_desc_context => p_lease_contacts_tbl(i).attribute_category
3770: , p_resp_appl_id => fnd_global.resp_appl_id
3771: , p_resp_id => fnd_global.resp_id
3772: , p_return_status => x_return_status
3773: );
3774:

Line 3771: , p_resp_id => fnd_global.resp_id

3767: , p_desc_segment14 => p_lease_contacts_tbl(i).attribute14
3768: , p_desc_segment15 => p_lease_contacts_tbl(i).attribute15
3769: , p_desc_context => p_lease_contacts_tbl(i).attribute_category
3770: , p_resp_appl_id => fnd_global.resp_appl_id
3771: , p_resp_id => fnd_global.resp_id
3772: , p_return_status => x_return_status
3773: );
3774:
3775: IF (x_return_status = fnd_api.g_ret_sts_error)

Line 5061: , p_resp_appl_id => fnd_global.resp_appl_id

5057: , p_desc_segment13 => p_lease_rec.attribute13
5058: , p_desc_segment14 => p_lease_rec.attribute14
5059: , p_desc_segment15 => p_lease_rec.attribute15
5060: , p_desc_context => p_lease_rec.attribute_category
5061: , p_resp_appl_id => fnd_global.resp_appl_id
5062: , p_resp_id => fnd_global.resp_id
5063: , p_return_status => x_return_status
5064: );
5065: IF (x_return_status = fnd_api.g_ret_sts_error)

Line 5062: , p_resp_id => fnd_global.resp_id

5058: , p_desc_segment14 => p_lease_rec.attribute14
5059: , p_desc_segment15 => p_lease_rec.attribute15
5060: , p_desc_context => p_lease_rec.attribute_category
5061: , p_resp_appl_id => fnd_global.resp_appl_id
5062: , p_resp_id => fnd_global.resp_id
5063: , p_return_status => x_return_status
5064: );
5065: IF (x_return_status = fnd_api.g_ret_sts_error)
5066: THEN

Line 5424: , x_created_by => fnd_global.user_id

5420: , x_abstracted_by_user => p_lease_rec.abstracted_by_user_id
5421: , x_status => p_lease_rec.status_code
5422: , x_lease_status => p_lease_rec.lease_status_code
5423: , x_creation_date => SYSDATE
5424: , x_created_by => fnd_global.user_id
5425: , x_last_update_date => p_lease_rec.last_update_date
5426: , x_last_updated_by => fnd_global.user_id
5427: , x_last_update_login => fnd_global.login_id
5428: , x_responsible_user => p_lease_rec.responsible_user_id

Line 5426: , x_last_updated_by => fnd_global.user_id

5422: , x_lease_status => p_lease_rec.lease_status_code
5423: , x_creation_date => SYSDATE
5424: , x_created_by => fnd_global.user_id
5425: , x_last_update_date => p_lease_rec.last_update_date
5426: , x_last_updated_by => fnd_global.user_id
5427: , x_last_update_login => fnd_global.login_id
5428: , x_responsible_user => p_lease_rec.responsible_user_id
5429: , x_expense_account_id => p_lease_exp_rev_accounts_rec.account_id
5430: , x_accrual_account_id => p_lease_accrual_account_rec.account_id

Line 5427: , x_last_update_login => fnd_global.login_id

5423: , x_creation_date => SYSDATE
5424: , x_created_by => fnd_global.user_id
5425: , x_last_update_date => p_lease_rec.last_update_date
5426: , x_last_updated_by => fnd_global.user_id
5427: , x_last_update_login => fnd_global.login_id
5428: , x_responsible_user => p_lease_rec.responsible_user_id
5429: , x_expense_account_id => p_lease_exp_rev_accounts_rec.account_id
5430: , x_accrual_account_id => p_lease_accrual_account_rec.account_id
5431: , x_receivable_account_id => p_lease_liab_rcvl_account_rec.account_id

Line 5624: , p_resp_appl_id => fnd_global.resp_appl_id

5620: , p_desc_segment13 =>p_note_tbl(l_index).attribute13
5621: , p_desc_segment14 =>p_note_tbl(l_index).attribute14
5622: , p_desc_segment15 =>p_note_tbl(l_index).attribute15
5623: , p_desc_context => p_note_tbl(l_index).attribute_category
5624: , p_resp_appl_id => fnd_global.resp_appl_id
5625: , p_resp_id => fnd_global.resp_id
5626: , p_return_status=> x_return_status
5627: );
5628: ----------dbms_output.put_line('NOTE HDR:x_return_status'||x_return_status);

Line 5625: , p_resp_id => fnd_global.resp_id

5621: , p_desc_segment14 =>p_note_tbl(l_index).attribute14
5622: , p_desc_segment15 =>p_note_tbl(l_index).attribute15
5623: , p_desc_context => p_note_tbl(l_index).attribute_category
5624: , p_resp_appl_id => fnd_global.resp_appl_id
5625: , p_resp_id => fnd_global.resp_id
5626: , p_return_status=> x_return_status
5627: );
5628: ----------dbms_output.put_line('NOTE HDR:x_return_status'||x_return_status);
5629: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 5715: , x_created_by => fnd_global.user_id

5711: , x_lease_id => p_lease_id
5712: , x_note_type_lookup_code => l_note_header_tbl(l_index).note_type_lookup_code
5713: , x_note_date => trunc(l_note_header_tbl(l_index).note_date)
5714: , x_creation_date => sysdate
5715: , x_created_by => fnd_global.user_id
5716: , x_last_update_date => sysdate
5717: , x_last_updated_by => fnd_global.user_id
5718: , x_last_update_login => fnd_global.user_id
5719: , x_attribute_category => l_note_header_tbl(l_index).attribute_category

Line 5717: , x_last_updated_by => fnd_global.user_id

5713: , x_note_date => trunc(l_note_header_tbl(l_index).note_date)
5714: , x_creation_date => sysdate
5715: , x_created_by => fnd_global.user_id
5716: , x_last_update_date => sysdate
5717: , x_last_updated_by => fnd_global.user_id
5718: , x_last_update_login => fnd_global.user_id
5719: , x_attribute_category => l_note_header_tbl(l_index).attribute_category
5720: , x_attribute1 => l_note_header_tbl(l_index).attribute1
5721: , x_attribute2 => l_note_header_tbl(l_index).attribute2

Line 5718: , x_last_update_login => fnd_global.user_id

5714: , x_creation_date => sysdate
5715: , x_created_by => fnd_global.user_id
5716: , x_last_update_date => sysdate
5717: , x_last_updated_by => fnd_global.user_id
5718: , x_last_update_login => fnd_global.user_id
5719: , x_attribute_category => l_note_header_tbl(l_index).attribute_category
5720: , x_attribute1 => l_note_header_tbl(l_index).attribute1
5721: , x_attribute2 => l_note_header_tbl(l_index).attribute2
5722: , x_attribute3 => l_note_header_tbl(l_index).attribute3

Line 5752: , x_created_by => fnd_global.user_id

5748: , x_note_detail_id => l_note_detail_id
5749: , x_note_header_id => l_note_header_tbl(l_index).note_header_id
5750: , x_text => l_note_header_tbl(l_index).text
5751: , x_creation_date => sysdate
5752: , x_created_by => fnd_global.user_id
5753: , x_last_update_date => sysdate
5754: , x_last_updated_by => fnd_global.user_id
5755: , x_last_update_login => fnd_global.user_id
5756: );

Line 5754: , x_last_updated_by => fnd_global.user_id

5750: , x_text => l_note_header_tbl(l_index).text
5751: , x_creation_date => sysdate
5752: , x_created_by => fnd_global.user_id
5753: , x_last_update_date => sysdate
5754: , x_last_updated_by => fnd_global.user_id
5755: , x_last_update_login => fnd_global.user_id
5756: );
5757:
5758: pvt_debug(g_pkg_name||'-NOTE_INSERT_ROW:PN_NOTE_DETAILS_PKG.INSERT_ROW Succesful',3);

Line 5755: , x_last_update_login => fnd_global.user_id

5751: , x_creation_date => sysdate
5752: , x_created_by => fnd_global.user_id
5753: , x_last_update_date => sysdate
5754: , x_last_updated_by => fnd_global.user_id
5755: , x_last_update_login => fnd_global.user_id
5756: );
5757:
5758: pvt_debug(g_pkg_name||'-NOTE_INSERT_ROW:PN_NOTE_DETAILS_PKG.INSERT_ROW Succesful',3);
5759: ------------------dbms_output.put_line('After calling note details'||l_note_detail_id);

Line 6043: , p_resp_appl_id => fnd_global.RESP_APPL_ID

6039: , p_desc_segment13 =>p_note_tbl(l_index).attribute13
6040: , p_desc_segment14 =>p_note_tbl(l_index).attribute14
6041: , p_desc_segment15 =>p_note_tbl(l_index).attribute15
6042: , p_desc_context => p_note_tbl(l_index).attribute_category
6043: , p_resp_appl_id => fnd_global.RESP_APPL_ID
6044: , p_resp_id => fnd_global.RESP_ID
6045: , p_return_status => l_return_status
6046: );
6047: ----------------------dbms_output.put_line('dff validated');

Line 6044: , p_resp_id => fnd_global.RESP_ID

6040: , p_desc_segment14 =>p_note_tbl(l_index).attribute14
6041: , p_desc_segment15 =>p_note_tbl(l_index).attribute15
6042: , p_desc_context => p_note_tbl(l_index).attribute_category
6043: , p_resp_appl_id => fnd_global.RESP_APPL_ID
6044: , p_resp_id => fnd_global.RESP_ID
6045: , p_return_status => l_return_status
6046: );
6047: ----------------------dbms_output.put_line('dff validated');
6048: IF (l_return_status = fnd_api.g_ret_sts_error)

Line 6111: , x_last_updated_by => fnd_global.user_id

6107: , x_lease_id => p_lease_id
6108: , x_note_type_lookup_code => p_note_tbl(l_index).note_type_lookup_code
6109: , x_note_date => trunc(p_note_tbl(l_index).note_date)
6110: , x_last_update_date => sysdate
6111: , x_last_updated_by => fnd_global.user_id
6112: , x_last_update_login => fnd_global.user_id
6113: , x_attribute_category => p_note_tbl(l_index).attribute_category
6114: , x_attribute1 => p_note_tbl(l_index).attribute1
6115: , x_attribute2 => p_note_tbl(l_index).attribute2

Line 6112: , x_last_update_login => fnd_global.user_id

6108: , x_note_type_lookup_code => p_note_tbl(l_index).note_type_lookup_code
6109: , x_note_date => trunc(p_note_tbl(l_index).note_date)
6110: , x_last_update_date => sysdate
6111: , x_last_updated_by => fnd_global.user_id
6112: , x_last_update_login => fnd_global.user_id
6113: , x_attribute_category => p_note_tbl(l_index).attribute_category
6114: , x_attribute1 => p_note_tbl(l_index).attribute1
6115: , x_attribute2 => p_note_tbl(l_index).attribute2
6116: , x_attribute3 => p_note_tbl(l_index).attribute3

Line 6161: , x_last_updated_by => fnd_global.user_id

6157: pn_note_details_pkg.update_row (
6158: x_note_detail_id => p_note_tbl(l_index).note_detail_id
6159: , x_text => p_note_tbl(l_index).text
6160: , x_last_update_date => sysdate
6161: , x_last_updated_by => fnd_global.user_id
6162: , x_last_update_login => fnd_global.user_id
6163: );
6164:
6165: IF (l_flag = 'Y') THEN

Line 6162: , x_last_update_login => fnd_global.user_id

6158: x_note_detail_id => p_note_tbl(l_index).note_detail_id
6159: , x_text => p_note_tbl(l_index).text
6160: , x_last_update_date => sysdate
6161: , x_last_updated_by => fnd_global.user_id
6162: , x_last_update_login => fnd_global.user_id
6163: );
6164:
6165: IF (l_flag = 'Y') THEN
6166: x_return_status:=fnd_api.g_ret_sts_success;

Line 6183: , x_created_by => fnd_global.user_id

6179: , x_note_detail_id => l_note_detail_id
6180: , x_note_header_id => p_note_tbl(l_index).note_header_id
6181: , x_text => p_note_tbl(l_index).text
6182: , x_creation_date => sysdate
6183: , x_created_by => fnd_global.user_id
6184: , x_last_update_date => sysdate
6185: , x_last_updated_by => fnd_global.user_id
6186: , x_last_update_login => fnd_global.user_id
6187: );

Line 6185: , x_last_updated_by => fnd_global.user_id

6181: , x_text => p_note_tbl(l_index).text
6182: , x_creation_date => sysdate
6183: , x_created_by => fnd_global.user_id
6184: , x_last_update_date => sysdate
6185: , x_last_updated_by => fnd_global.user_id
6186: , x_last_update_login => fnd_global.user_id
6187: );
6188:
6189: IF (l_flag = 'Y') THEN

Line 6186: , x_last_update_login => fnd_global.user_id

6182: , x_creation_date => sysdate
6183: , x_created_by => fnd_global.user_id
6184: , x_last_update_date => sysdate
6185: , x_last_updated_by => fnd_global.user_id
6186: , x_last_update_login => fnd_global.user_id
6187: );
6188:
6189: IF (l_flag = 'Y') THEN
6190: x_return_status:=fnd_api.g_ret_sts_success;

Line 6496: , p_resp_appl_id => fnd_global.RESP_APPL_ID

6492: , p_desc_segment13 =>p_right_tbl(l_index).attribute13
6493: , p_desc_segment14 =>p_right_tbl(l_index).attribute14
6494: , p_desc_segment15 =>p_right_tbl(l_index).attribute15
6495: , p_desc_context => p_right_tbl(l_index).attribute_category
6496: , p_resp_appl_id => fnd_global.RESP_APPL_ID
6497: , p_resp_id => fnd_global.RESP_ID
6498: , p_return_status => x_return_status
6499: );
6500: IF (x_return_status = fnd_api.g_ret_sts_error)

Line 6497: , p_resp_id => fnd_global.RESP_ID

6493: , p_desc_segment14 =>p_right_tbl(l_index).attribute14
6494: , p_desc_segment15 =>p_right_tbl(l_index).attribute15
6495: , p_desc_context => p_right_tbl(l_index).attribute_category
6496: , p_resp_appl_id => fnd_global.RESP_APPL_ID
6497: , p_resp_id => fnd_global.RESP_ID
6498: , p_return_status => x_return_status
6499: );
6500: IF (x_return_status = fnd_api.g_ret_sts_error)
6501: THEN

Line 6592: , x_created_by => fnd_global.user_id

6588: , x_attribute13 => p_right_tbl(l_index).attribute13
6589: , x_attribute14 => p_right_tbl(l_index).attribute14
6590: , x_attribute15 => p_right_tbl(l_index).attribute15
6591: , x_creation_date => sysdate
6592: , x_created_by => fnd_global.user_id
6593: , x_last_update_date => sysdate
6594: , x_last_updated_by => fnd_global.user_id
6595: , x_last_update_login => fnd_global.user_id
6596: , x_org_id => fnd_global.org_id

Line 6594: , x_last_updated_by => fnd_global.user_id

6590: , x_attribute15 => p_right_tbl(l_index).attribute15
6591: , x_creation_date => sysdate
6592: , x_created_by => fnd_global.user_id
6593: , x_last_update_date => sysdate
6594: , x_last_updated_by => fnd_global.user_id
6595: , x_last_update_login => fnd_global.user_id
6596: , x_org_id => fnd_global.org_id
6597: );
6598:

Line 6595: , x_last_update_login => fnd_global.user_id

6591: , x_creation_date => sysdate
6592: , x_created_by => fnd_global.user_id
6593: , x_last_update_date => sysdate
6594: , x_last_updated_by => fnd_global.user_id
6595: , x_last_update_login => fnd_global.user_id
6596: , x_org_id => fnd_global.org_id
6597: );
6598:
6599: ----------------------dbms_output.put_line('RECORD FOR RIGHTS CREATED WITH RIGHT ID: '|| l_right_id);--Rupak

Line 6596: , x_org_id => fnd_global.org_id

6592: , x_created_by => fnd_global.user_id
6593: , x_last_update_date => sysdate
6594: , x_last_updated_by => fnd_global.user_id
6595: , x_last_update_login => fnd_global.user_id
6596: , x_org_id => fnd_global.org_id
6597: );
6598:
6599: ----------------------dbms_output.put_line('RECORD FOR RIGHTS CREATED WITH RIGHT ID: '|| l_right_id);--Rupak
6600: pvt_debug(g_pkg_name||'-RIGHT_INSERT_ROW:PN_RIGHTS_PKG.INSERT_ROW Successful',3);

Line 6962: , p_resp_appl_id => fnd_global.resp_appl_id

6958: , p_desc_segment13 =>p_right_tbl(l_index).attribute13
6959: , p_desc_segment14 =>p_right_tbl(l_index).attribute14
6960: , p_desc_segment15 =>p_right_tbl(l_index).attribute15
6961: , p_desc_context => p_right_tbl(l_index).attribute_category
6962: , p_resp_appl_id => fnd_global.resp_appl_id
6963: , p_resp_id => fnd_global.resp_id
6964: , p_return_status => x_return_status
6965: );
6966: --------------------dbms_output.put_line('dff validated');

Line 6963: , p_resp_id => fnd_global.resp_id

6959: , p_desc_segment14 =>p_right_tbl(l_index).attribute14
6960: , p_desc_segment15 =>p_right_tbl(l_index).attribute15
6961: , p_desc_context => p_right_tbl(l_index).attribute_category
6962: , p_resp_appl_id => fnd_global.resp_appl_id
6963: , p_resp_id => fnd_global.resp_id
6964: , p_return_status => x_return_status
6965: );
6966: --------------------dbms_output.put_line('dff validated');
6967: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 7051: , x_last_updated_by => fnd_global.user_id

7047: , x_attribute13 => p_right_tbl(l_index).attribute13
7048: , x_attribute14 => p_right_tbl(l_index).attribute14
7049: , x_attribute15 => p_right_tbl(l_index).attribute15
7050: , x_last_update_date => sysdate
7051: , x_last_updated_by => fnd_global.user_id
7052: , x_last_update_login => fnd_global.user_id
7053: );
7054:
7055:

Line 7052: , x_last_update_login => fnd_global.user_id

7048: , x_attribute14 => p_right_tbl(l_index).attribute14
7049: , x_attribute15 => p_right_tbl(l_index).attribute15
7050: , x_last_update_date => sysdate
7051: , x_last_updated_by => fnd_global.user_id
7052: , x_last_update_login => fnd_global.user_id
7053: );
7054:
7055:
7056: ----------------------dbms_output.put_line ('RECORD UPDATION COMPLETED FOR RIGHTS');--Rupak

Line 7492: , p_resp_appl_id => fnd_global.resp_appl_id

7488: , p_desc_segment13 =>p_obligation_tbl(l_index).attribute13
7489: , p_desc_segment14 =>p_obligation_tbl(l_index).attribute14
7490: , p_desc_segment15 =>p_obligation_tbl(l_index).attribute15
7491: , p_desc_context => p_obligation_tbl(l_index).attribute_category
7492: , p_resp_appl_id => fnd_global.resp_appl_id
7493: , p_resp_id => fnd_global.resp_id
7494: , p_return_status => x_return_status
7495: );
7496: ----------------------dbms_output.put_line('dff validated');

Line 7493: , p_resp_id => fnd_global.resp_id

7489: , p_desc_segment14 =>p_obligation_tbl(l_index).attribute14
7490: , p_desc_segment15 =>p_obligation_tbl(l_index).attribute15
7491: , p_desc_context => p_obligation_tbl(l_index).attribute_category
7492: , p_resp_appl_id => fnd_global.resp_appl_id
7493: , p_resp_id => fnd_global.resp_id
7494: , p_return_status => x_return_status
7495: );
7496: ----------------------dbms_output.put_line('dff validated');
7497: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 7589: X_CREATED_BY => fnd_global.user_id,

7585: X_ATTRIBUTE13 => p_obligation_tbl(l_index).attribute1,
7586: X_ATTRIBUTE14 => p_obligation_tbl(l_index).attribute1,
7587: X_ATTRIBUTE15 => p_obligation_tbl(l_index).attribute1,
7588: X_CREATION_DATE => sysdate,
7589: X_CREATED_BY => fnd_global.user_id,
7590: X_LAST_UPDATE_DATE => sysdate,
7591: X_LAST_UPDATED_BY => fnd_global.user_id,
7592: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
7593: X_OBLIGATION_NUM => p_obligation_tbl(l_index).obligation_num,

Line 7591: X_LAST_UPDATED_BY => fnd_global.user_id,

7587: X_ATTRIBUTE15 => p_obligation_tbl(l_index).attribute1,
7588: X_CREATION_DATE => sysdate,
7589: X_CREATED_BY => fnd_global.user_id,
7590: X_LAST_UPDATE_DATE => sysdate,
7591: X_LAST_UPDATED_BY => fnd_global.user_id,
7592: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
7593: X_OBLIGATION_NUM => p_obligation_tbl(l_index).obligation_num,
7594: X_RESPONSIBILITY_CODE => p_obligation_tbl(l_index).responsibility_code,
7595: X_COMMON_AREA_RESP => p_obligation_tbl(l_index).common_area_resp,

Line 7592: X_LAST_UPDATE_LOGIN => fnd_global.user_id,

7588: X_CREATION_DATE => sysdate,
7589: X_CREATED_BY => fnd_global.user_id,
7590: X_LAST_UPDATE_DATE => sysdate,
7591: X_LAST_UPDATED_BY => fnd_global.user_id,
7592: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
7593: X_OBLIGATION_NUM => p_obligation_tbl(l_index).obligation_num,
7594: X_RESPONSIBILITY_CODE => p_obligation_tbl(l_index).responsibility_code,
7595: X_COMMON_AREA_RESP => p_obligation_tbl(l_index).common_area_resp,
7596: X_FINANCIAL_RESP_PARTY_CODE => p_obligation_tbl(l_index).financial_resp_party_code,

Line 7602: X_org_id => fnd_global.org_id

7598: X_RESPONSIBILITY_MAINT => p_obligation_tbl(l_index).responsibility_maint,
7599: X_COMPANY_ID => p_obligation_tbl(l_index).company_id,
7600: X_OBLIGATION_REFERENCE => p_obligation_tbl(l_index).obligation_reference,
7601: X_OBLIGATION_COMMENTS => p_obligation_tbl(l_index).obligation_comments,
7602: X_org_id => fnd_global.org_id
7603: );
7604: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:PN_LANDLORD_SERVICES_PKG.INSERT_ROW Successful',3);
7605: ----------------------dbms_output.put_line (' RECORD : '||l_index|| ' WITH landlord_service_id: '||l_landlord_service_id||' INSERTED');
7606: p_obligation_tbl(l_index).landlord_service_id := p_obligation_tbl(l_index).landlord_service_id;

Line 8064: , p_resp_appl_id => fnd_global.resp_appl_id

8060: , p_desc_segment13 =>p_obligation_tbl(l_index).attribute13
8061: , p_desc_segment14 =>p_obligation_tbl(l_index).attribute14
8062: , p_desc_segment15 =>p_obligation_tbl(l_index).attribute15
8063: , p_desc_context => p_obligation_tbl(l_index).attribute_category
8064: , p_resp_appl_id => fnd_global.resp_appl_id
8065: , p_resp_id => fnd_global.resp_id
8066: , p_return_status=> x_return_status
8067: );
8068: --------------------dbms_output.put_line('dff validated');

Line 8065: , p_resp_id => fnd_global.resp_id

8061: , p_desc_segment14 =>p_obligation_tbl(l_index).attribute14
8062: , p_desc_segment15 =>p_obligation_tbl(l_index).attribute15
8063: , p_desc_context => p_obligation_tbl(l_index).attribute_category
8064: , p_resp_appl_id => fnd_global.resp_appl_id
8065: , p_resp_id => fnd_global.resp_id
8066: , p_return_status=> x_return_status
8067: );
8068: --------------------dbms_output.put_line('dff validated');
8069: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 8156: X_LAST_UPDATED_BY => fnd_global.user_id,

8152: X_ATTRIBUTE13 => p_obligation_tbl(l_index).attribute1,
8153: X_ATTRIBUTE14 => p_obligation_tbl(l_index).attribute1,
8154: X_ATTRIBUTE15 => p_obligation_tbl(l_index).attribute1,
8155: X_LAST_UPDATE_DATE => sysdate,
8156: X_LAST_UPDATED_BY => fnd_global.user_id,
8157: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
8158: X_OBLIGATION_NUM => p_obligation_tbl(l_index).obligation_num,
8159: X_RESPONSIBILITY_CODE => p_obligation_tbl(l_index).responsibility_code,
8160: X_COMMON_AREA_RESP => p_obligation_tbl(l_index).common_area_resp,

Line 8157: X_LAST_UPDATE_LOGIN => fnd_global.user_id,

8153: X_ATTRIBUTE14 => p_obligation_tbl(l_index).attribute1,
8154: X_ATTRIBUTE15 => p_obligation_tbl(l_index).attribute1,
8155: X_LAST_UPDATE_DATE => sysdate,
8156: X_LAST_UPDATED_BY => fnd_global.user_id,
8157: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
8158: X_OBLIGATION_NUM => p_obligation_tbl(l_index).obligation_num,
8159: X_RESPONSIBILITY_CODE => p_obligation_tbl(l_index).responsibility_code,
8160: X_COMMON_AREA_RESP => p_obligation_tbl(l_index).common_area_resp,
8161: X_FINANCIAL_RESP_PARTY_CODE => p_obligation_tbl(l_index).financial_resp_party_code,

Line 8459: , p_resp_appl_id => fnd_global.RESP_APPL_ID

8455: , p_desc_segment13 =>p_milestone_tbl(l_index).attribute13
8456: , p_desc_segment14 =>p_milestone_tbl(l_index).attribute14
8457: , p_desc_segment15 =>p_milestone_tbl(l_index).attribute15
8458: , p_desc_context => p_milestone_tbl(l_index).attribute_category
8459: , p_resp_appl_id => fnd_global.RESP_APPL_ID
8460: , p_resp_id => fnd_global.RESP_ID
8461: , p_return_status => x_return_status
8462: );
8463: IF (x_return_status = fnd_api.g_ret_sts_error)

Line 8460: , p_resp_id => fnd_global.RESP_ID

8456: , p_desc_segment14 =>p_milestone_tbl(l_index).attribute14
8457: , p_desc_segment15 =>p_milestone_tbl(l_index).attribute15
8458: , p_desc_context => p_milestone_tbl(l_index).attribute_category
8459: , p_resp_appl_id => fnd_global.RESP_APPL_ID
8460: , p_resp_id => fnd_global.RESP_ID
8461: , p_return_status => x_return_status
8462: );
8463: IF (x_return_status = fnd_api.g_ret_sts_error)
8464: THEN

Line 8564: X_CREATED_BY => fnd_global.user_id,

8560: X_MILESTONE_DATE => p_milestone_tbl(l_index).action_due_date,
8561: X_USER_ID => p_milestone_tbl(l_index).user_id,
8562: X_LEASE_ID => p_lease_id,
8563: X_CREATION_DATE => sysdate,
8564: X_CREATED_BY => fnd_global.user_id,
8565: X_LAST_UPDATE_DATE => sysdate,
8566: X_LAST_UPDATED_BY => fnd_global.user_id,
8567: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
8568: x_org_id => fnd_global.org_id

Line 8566: X_LAST_UPDATED_BY => fnd_global.user_id,

8562: X_LEASE_ID => p_lease_id,
8563: X_CREATION_DATE => sysdate,
8564: X_CREATED_BY => fnd_global.user_id,
8565: X_LAST_UPDATE_DATE => sysdate,
8566: X_LAST_UPDATED_BY => fnd_global.user_id,
8567: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
8568: x_org_id => fnd_global.org_id
8569: );
8570:

Line 8567: X_LAST_UPDATE_LOGIN => fnd_global.user_id,

8563: X_CREATION_DATE => sysdate,
8564: X_CREATED_BY => fnd_global.user_id,
8565: X_LAST_UPDATE_DATE => sysdate,
8566: X_LAST_UPDATED_BY => fnd_global.user_id,
8567: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
8568: x_org_id => fnd_global.org_id
8569: );
8570:
8571: ----------------------dbms_output.put_line('RECORD FOR MILESTONE CREATED WITH MILESTONE ID: '|| l_milestone_id);--Rupak

Line 8568: x_org_id => fnd_global.org_id

8564: X_CREATED_BY => fnd_global.user_id,
8565: X_LAST_UPDATE_DATE => sysdate,
8566: X_LAST_UPDATED_BY => fnd_global.user_id,
8567: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
8568: x_org_id => fnd_global.org_id
8569: );
8570:
8571: ----------------------dbms_output.put_line('RECORD FOR MILESTONE CREATED WITH MILESTONE ID: '|| l_milestone_id);--Rupak
8572: pvt_debug(g_pkg_name||'-MILESTONE_INSERT_ROW:Calling PN_LEASE_MILESTONES_PKG.INSERT_ROW Successful',3);

Line 8936: , p_resp_appl_id => fnd_global.resp_appl_id

8932: , p_desc_segment13 =>p_milestone_tbl(l_index).attribute13
8933: , p_desc_segment14 =>p_milestone_tbl(l_index).attribute14
8934: , p_desc_segment15 =>p_milestone_tbl(l_index).attribute15
8935: , p_desc_context => p_milestone_tbl(l_index).attribute_category
8936: , p_resp_appl_id => fnd_global.resp_appl_id
8937: , p_resp_id => fnd_global.resp_id
8938: , p_return_status=> x_return_status
8939: );
8940: ----------------------dbms_output.put_line('dff validatedMILESTONES');--Rupak

Line 8937: , p_resp_id => fnd_global.resp_id

8933: , p_desc_segment14 =>p_milestone_tbl(l_index).attribute14
8934: , p_desc_segment15 =>p_milestone_tbl(l_index).attribute15
8935: , p_desc_context => p_milestone_tbl(l_index).attribute_category
8936: , p_resp_appl_id => fnd_global.resp_appl_id
8937: , p_resp_id => fnd_global.resp_id
8938: , p_return_status=> x_return_status
8939: );
8940: ----------------------dbms_output.put_line('dff validatedMILESTONES');--Rupak
8941: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 9037: X_LAST_UPDATED_BY => fnd_global.user_id,

9033: X_MILESTONE_DATE => p_milestone_tbl(l_index).action_due_date,
9034: X_USER_ID => p_milestone_tbl(l_index).user_id,
9035: X_LEASE_ID => p_lease_id,
9036: X_LAST_UPDATE_DATE => sysdate,
9037: X_LAST_UPDATED_BY => fnd_global.user_id,
9038: X_LAST_UPDATE_LOGIN => fnd_global.user_id
9039: );
9040:
9041: ----------------------dbms_output.put_line ('RECORD UPDATION COMPLETED FOR MILESTONES');--Rupak

Line 9038: X_LAST_UPDATE_LOGIN => fnd_global.user_id

9034: X_USER_ID => p_milestone_tbl(l_index).user_id,
9035: X_LEASE_ID => p_lease_id,
9036: X_LAST_UPDATE_DATE => sysdate,
9037: X_LAST_UPDATED_BY => fnd_global.user_id,
9038: X_LAST_UPDATE_LOGIN => fnd_global.user_id
9039: );
9040:
9041: ----------------------dbms_output.put_line ('RECORD UPDATION COMPLETED FOR MILESTONES');--Rupak
9042: pvt_debug(g_pkg_name||'-MILESTONE_UPDATE_ROW:PN_LEASE_MILESTONES_PKG.UPDATE_ROW Successful',3);

Line 9382: , p_resp_appl_id => fnd_global.resp_appl_id

9378: , p_desc_segment13 =>p_insurance_tbl(l_index).attribute13
9379: , p_desc_segment14 =>p_insurance_tbl(l_index).attribute14
9380: , p_desc_segment15 =>p_insurance_tbl(l_index).attribute15
9381: , p_desc_context => p_insurance_tbl(l_index).attribute_category
9382: , p_resp_appl_id => fnd_global.resp_appl_id
9383: , p_resp_id => fnd_global.resp_id
9384: , p_return_status => x_return_status
9385: );
9386:

Line 9383: , p_resp_id => fnd_global.resp_id

9379: , p_desc_segment14 =>p_insurance_tbl(l_index).attribute14
9380: , p_desc_segment15 =>p_insurance_tbl(l_index).attribute15
9381: , p_desc_context => p_insurance_tbl(l_index).attribute_category
9382: , p_resp_appl_id => fnd_global.resp_appl_id
9383: , p_resp_id => fnd_global.resp_id
9384: , p_return_status => x_return_status
9385: );
9386:
9387: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 9484: ,X_CREATED_BY => fnd_global.user_id

9480: ,X_ATTRIBUTE13 => p_insurance_tbl(l_index).attribute13
9481: ,X_ATTRIBUTE14 => p_insurance_tbl(l_index).attribute14
9482: ,X_ATTRIBUTE15 => p_insurance_tbl(l_index).attribute15
9483: ,X_CREATION_DATE => sysdate
9484: ,X_CREATED_BY => fnd_global.user_id
9485: ,X_LAST_UPDATE_DATE => sysdate
9486: ,X_LAST_UPDATED_BY => fnd_global.user_id
9487: ,X_LAST_UPDATE_LOGIN => fnd_global.user_id
9488: ,x_org_id => g_org_id

Line 9486: ,X_LAST_UPDATED_BY => fnd_global.user_id

9482: ,X_ATTRIBUTE15 => p_insurance_tbl(l_index).attribute15
9483: ,X_CREATION_DATE => sysdate
9484: ,X_CREATED_BY => fnd_global.user_id
9485: ,X_LAST_UPDATE_DATE => sysdate
9486: ,X_LAST_UPDATED_BY => fnd_global.user_id
9487: ,X_LAST_UPDATE_LOGIN => fnd_global.user_id
9488: ,x_org_id => g_org_id
9489: );
9490:

Line 9487: ,X_LAST_UPDATE_LOGIN => fnd_global.user_id

9483: ,X_CREATION_DATE => sysdate
9484: ,X_CREATED_BY => fnd_global.user_id
9485: ,X_LAST_UPDATE_DATE => sysdate
9486: ,X_LAST_UPDATED_BY => fnd_global.user_id
9487: ,X_LAST_UPDATE_LOGIN => fnd_global.user_id
9488: ,x_org_id => g_org_id
9489: );
9490:
9491: --SAVEPOINT A;

Line 9915: , p_resp_appl_id => fnd_global.resp_appl_id

9911: , p_desc_segment13 =>p_insurance_tbl(l_index).attribute13
9912: , p_desc_segment14 =>p_insurance_tbl(l_index).attribute14
9913: , p_desc_segment15 =>p_insurance_tbl(l_index).attribute15
9914: , p_desc_context => p_insurance_tbl(l_index).attribute_category
9915: , p_resp_appl_id => fnd_global.resp_appl_id
9916: , p_resp_id => fnd_global.resp_id
9917: , p_return_status=> x_return_status
9918: );
9919: ----------------------dbms_output.put_line('dff validated');--Rupak

Line 9916: , p_resp_id => fnd_global.resp_id

9912: , p_desc_segment14 =>p_insurance_tbl(l_index).attribute14
9913: , p_desc_segment15 =>p_insurance_tbl(l_index).attribute15
9914: , p_desc_context => p_insurance_tbl(l_index).attribute_category
9915: , p_resp_appl_id => fnd_global.resp_appl_id
9916: , p_resp_id => fnd_global.resp_id
9917: , p_return_status=> x_return_status
9918: );
9919: ----------------------dbms_output.put_line('dff validated');--Rupak
9920: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 10015: X_LAST_UPDATED_BY => fnd_global.user_id,

10011: X_ATTRIBUTE13 => p_insurance_tbl(l_index).attribute13,
10012: X_ATTRIBUTE14 => p_insurance_tbl(l_index).attribute14,
10013: X_ATTRIBUTE15 => p_insurance_tbl(l_index).attribute15,
10014: X_LAST_UPDATE_DATE => sysdate,
10015: X_LAST_UPDATED_BY => fnd_global.user_id,
10016: X_LAST_UPDATE_LOGIN => fnd_global.login_id
10017: );
10018:
10019: --SAVEPOINT A;

Line 10016: X_LAST_UPDATE_LOGIN => fnd_global.login_id

10012: X_ATTRIBUTE14 => p_insurance_tbl(l_index).attribute14,
10013: X_ATTRIBUTE15 => p_insurance_tbl(l_index).attribute15,
10014: X_LAST_UPDATE_DATE => sysdate,
10015: X_LAST_UPDATED_BY => fnd_global.user_id,
10016: X_LAST_UPDATE_LOGIN => fnd_global.login_id
10017: );
10018:
10019: --SAVEPOINT A;
10020: ----------------------dbms_output.put_line('UPDATE PROCEDURE FOR RECORD: '||l_index ||'COMPLETED');--Rupak

Line 10492: , p_resp_appl_id => fnd_global.resp_appl_id

10488: , p_desc_segment13 =>p_option_tbl(l_index).attribute13
10489: , p_desc_segment14 =>p_option_tbl(l_index).attribute14
10490: , p_desc_segment15 =>p_option_tbl(l_index).attribute15
10491: , p_desc_context => p_option_tbl(l_index).attribute_category
10492: , p_resp_appl_id => fnd_global.resp_appl_id
10493: , p_resp_id => fnd_global.resp_id
10494: , p_return_status => x_return_status
10495: );
10496: ----------------------dbms_output.put_line('DFF VALIDATED');

Line 10493: , p_resp_id => fnd_global.resp_id

10489: , p_desc_segment14 =>p_option_tbl(l_index).attribute14
10490: , p_desc_segment15 =>p_option_tbl(l_index).attribute15
10491: , p_desc_context => p_option_tbl(l_index).attribute_category
10492: , p_resp_appl_id => fnd_global.resp_appl_id
10493: , p_resp_id => fnd_global.resp_id
10494: , p_return_status => x_return_status
10495: );
10496: ----------------------dbms_output.put_line('DFF VALIDATED');
10497: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 10595: , x_created_by => fnd_global.user_id

10591: , x_attribute11 => p_option_tbl(l_index).attribute11
10592: , x_attribute12 => p_option_tbl(l_index).attribute12
10593: , x_attribute13 => p_option_tbl(l_index).attribute13
10594: , x_creation_date => sysdate
10595: , x_created_by => fnd_global.user_id
10596: , x_last_update_date => sysdate
10597: , x_last_updated_by => fnd_global.user_id
10598: , x_last_update_login => fnd_global.login_id
10599: , x_option_exer_start_date => p_option_tbl(l_index).option_exer_start_date

Line 10597: , x_last_updated_by => fnd_global.user_id

10593: , x_attribute13 => p_option_tbl(l_index).attribute13
10594: , x_creation_date => sysdate
10595: , x_created_by => fnd_global.user_id
10596: , x_last_update_date => sysdate
10597: , x_last_updated_by => fnd_global.user_id
10598: , x_last_update_login => fnd_global.login_id
10599: , x_option_exer_start_date => p_option_tbl(l_index).option_exer_start_date
10600: , x_option_exer_end_date => p_option_tbl(l_index).option_exer_end_date
10601: , x_option_action_date => p_option_tbl(l_index).option_action_date

Line 10598: , x_last_update_login => fnd_global.login_id

10594: , x_creation_date => sysdate
10595: , x_created_by => fnd_global.user_id
10596: , x_last_update_date => sysdate
10597: , x_last_updated_by => fnd_global.user_id
10598: , x_last_update_login => fnd_global.login_id
10599: , x_option_exer_start_date => p_option_tbl(l_index).option_exer_start_date
10600: , x_option_exer_end_date => p_option_tbl(l_index).option_exer_end_date
10601: , x_option_action_date => p_option_tbl(l_index).option_action_date
10602: , x_option_cost => p_option_tbl(l_index).option_cost

Line 10607: , x_org_id => fnd_global.org_id

10603: , x_option_area_change => p_option_tbl(l_index).option_area_change
10604: , x_option_reference => p_option_tbl(l_index).option_reference
10605: , x_option_notice_reqd => p_option_tbl(l_index).option_notice_reqd
10606: , x_option_comments => p_option_tbl(l_index).comments
10607: , x_org_id => fnd_global.org_id
10608: );
10609:
10610: ----------------------dbms_output.put_line('Options:AFter Insert Row');--Rupak
10611: pvt_debug(g_pkg_name||'OPTION_INSERT_ROW:Calling PN_OPTIONS_PKG.INSERT_ROW Successful',3);

Line 11149: , p_resp_appl_id => fnd_global.resp_appl_id

11145: , p_desc_segment13 =>p_option_tbl(l_index).attribute13
11146: , p_desc_segment14 =>p_option_tbl(l_index).attribute14
11147: , p_desc_segment15 =>p_option_tbl(l_index).attribute15
11148: , p_desc_context => p_option_tbl(l_index).attribute_category
11149: , p_resp_appl_id => fnd_global.resp_appl_id
11150: , p_resp_id => fnd_global.resp_id
11151: , p_return_status => x_return_status
11152: );
11153: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

Line 11150: , p_resp_id => fnd_global.resp_id

11146: , p_desc_segment14 =>p_option_tbl(l_index).attribute14
11147: , p_desc_segment15 =>p_option_tbl(l_index).attribute15
11148: , p_desc_context => p_option_tbl(l_index).attribute_category
11149: , p_resp_appl_id => fnd_global.resp_appl_id
11150: , p_resp_id => fnd_global.resp_id
11151: , p_return_status => x_return_status
11152: );
11153: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
11154: l_tbl_flag := 0;

Line 11251: , x_last_updated_by => fnd_global.user_id

11247: , x_attribute13 => p_option_tbl(l_index).attribute13
11248: , x_attribute14 => p_option_tbl(l_index).attribute14
11249: , x_attribute15 => p_option_tbl(l_index).attribute15
11250: , x_last_update_date => sysdate
11251: , x_last_updated_by => fnd_global.user_id
11252: , x_last_update_login => fnd_global.login_id
11253: , x_option_exer_start_date => p_option_tbl(l_index).option_exer_start_date
11254: , x_option_exer_end_date => p_option_tbl(l_index).option_exer_end_date
11255: , x_option_action_date => p_option_tbl(l_index).option_action_date

Line 11252: , x_last_update_login => fnd_global.login_id

11248: , x_attribute14 => p_option_tbl(l_index).attribute14
11249: , x_attribute15 => p_option_tbl(l_index).attribute15
11250: , x_last_update_date => sysdate
11251: , x_last_updated_by => fnd_global.user_id
11252: , x_last_update_login => fnd_global.login_id
11253: , x_option_exer_start_date => p_option_tbl(l_index).option_exer_start_date
11254: , x_option_exer_end_date => p_option_tbl(l_index).option_exer_end_date
11255: , x_option_action_date => p_option_tbl(l_index).option_action_date
11256: , x_option_cost => p_option_tbl(l_index).option_cost

Line 13030: , p_resp_appl_id => fnd_global.resp_appl_id

13026: , p_desc_segment13 => l_lease_rec.attribute13
13027: , p_desc_segment14 => l_lease_rec.attribute14
13028: , p_desc_segment15 => l_lease_rec.attribute15
13029: , p_desc_context => l_lease_rec.attribute_category
13030: , p_resp_appl_id => fnd_global.resp_appl_id
13031: --pn_lease_pub.g_resp_appl_id
13032: , p_resp_id => fnd_global.resp_id
13033: --pn_lease_pub.g_resp_id
13034: , p_return_status => x_return_status

Line 13032: , p_resp_id => fnd_global.resp_id

13028: , p_desc_segment15 => l_lease_rec.attribute15
13029: , p_desc_context => l_lease_rec.attribute_category
13030: , p_resp_appl_id => fnd_global.resp_appl_id
13031: --pn_lease_pub.g_resp_appl_id
13032: , p_resp_id => fnd_global.resp_id
13033: --pn_lease_pub.g_resp_id
13034: , p_return_status => x_return_status
13035: );
13036: pvt_debug(g_pkg_name||'UPDATE_LEASE:ATTRIBUTES: Return Status:'||x_return_status,3);

Line 13647: ,x_last_updated_by => fnd_global.user_id

13643: ,x_account_class => p_terms_exp_rev_accounts_tbl(i).account_code
13644: ,x_percentage => p_terms_exp_rev_accounts_tbl(i).account_percentage
13645: ,x_line_number => r_dist_details.line_number
13646: ,x_last_update_date => SYSDATE
13647: ,x_last_updated_by => fnd_global.user_id
13648: ,x_last_update_login => fnd_global.login_id
13649: ,x_attribute_category => r_dist_details.attribute_category
13650: ,x_attribute1 => r_dist_details.attribute1
13651: ,x_attribute2 => r_dist_details.attribute2

Line 13648: ,x_last_update_login => fnd_global.login_id

13644: ,x_percentage => p_terms_exp_rev_accounts_tbl(i).account_percentage
13645: ,x_line_number => r_dist_details.line_number
13646: ,x_last_update_date => SYSDATE
13647: ,x_last_updated_by => fnd_global.user_id
13648: ,x_last_update_login => fnd_global.login_id
13649: ,x_attribute_category => r_dist_details.attribute_category
13650: ,x_attribute1 => r_dist_details.attribute1
13651: ,x_attribute2 => r_dist_details.attribute2
13652: ,x_attribute3 => r_dist_details.attribute3

Line 13689: ,x_last_updated_by => fnd_global.user_id

13685: ,x_account_class => p_terms_exp_rev_accounts_tbl(i).account_code
13686: ,x_percentage => p_terms_exp_rev_accounts_tbl(i).account_percentage
13687: ,x_line_number => l_max_rownum
13688: ,x_last_update_date => SYSDATE
13689: ,x_last_updated_by => fnd_global.user_id
13690: ,x_creation_date => SYSDATE
13691: ,x_created_by => fnd_global.user_id
13692: ,x_last_update_login => fnd_global.login_id
13693: ,x_attribute_category => NULL

Line 13691: ,x_created_by => fnd_global.user_id

13687: ,x_line_number => l_max_rownum
13688: ,x_last_update_date => SYSDATE
13689: ,x_last_updated_by => fnd_global.user_id
13690: ,x_creation_date => SYSDATE
13691: ,x_created_by => fnd_global.user_id
13692: ,x_last_update_login => fnd_global.login_id
13693: ,x_attribute_category => NULL
13694: ,x_attribute1 => NULL
13695: ,x_attribute2 => NULL

Line 13692: ,x_last_update_login => fnd_global.login_id

13688: ,x_last_update_date => SYSDATE
13689: ,x_last_updated_by => fnd_global.user_id
13690: ,x_creation_date => SYSDATE
13691: ,x_created_by => fnd_global.user_id
13692: ,x_last_update_login => fnd_global.login_id
13693: ,x_attribute_category => NULL
13694: ,x_attribute1 => NULL
13695: ,x_attribute2 => NULL
13696: ,x_attribute3 => NULL

Line 13709: ,x_org_id => fnd_global.org_id

13705: ,x_attribute12 => NULL
13706: ,x_attribute13 => NULL
13707: ,x_attribute14 => NULL
13708: ,x_attribute15 => NULL
13709: ,x_org_id => fnd_global.org_id
13710: );
13711: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);
13712: commit;
13713: --------dbms_output.put_line('IN ELSE:INSERT ROW');

Line 13739: ,x_last_updated_by => fnd_global.user_id

13735: ,x_account_class => p_terms_exp_rev_accounts_tbl(i).account_code
13736: ,x_percentage => p_terms_exp_rev_accounts_tbl(i).account_percentage
13737: ,x_line_number => l_max_rownum
13738: ,x_last_update_date => SYSDATE
13739: ,x_last_updated_by => fnd_global.user_id
13740: ,x_creation_date => SYSDATE
13741: ,x_created_by => fnd_global.user_id
13742: ,x_last_update_login => fnd_global.login_id
13743: ,x_attribute_category => NULL

Line 13741: ,x_created_by => fnd_global.user_id

13737: ,x_line_number => l_max_rownum
13738: ,x_last_update_date => SYSDATE
13739: ,x_last_updated_by => fnd_global.user_id
13740: ,x_creation_date => SYSDATE
13741: ,x_created_by => fnd_global.user_id
13742: ,x_last_update_login => fnd_global.login_id
13743: ,x_attribute_category => NULL
13744: ,x_attribute1 => NULL
13745: ,x_attribute2 => NULL

Line 13742: ,x_last_update_login => fnd_global.login_id

13738: ,x_last_update_date => SYSDATE
13739: ,x_last_updated_by => fnd_global.user_id
13740: ,x_creation_date => SYSDATE
13741: ,x_created_by => fnd_global.user_id
13742: ,x_last_update_login => fnd_global.login_id
13743: ,x_attribute_category => NULL
13744: ,x_attribute1 => NULL
13745: ,x_attribute2 => NULL
13746: ,x_attribute3 => NULL

Line 13759: ,x_org_id => fnd_global.org_id

13755: ,x_attribute12 => NULL
13756: ,x_attribute13 => NULL
13757: ,x_attribute14 => NULL
13758: ,x_attribute15 => NULL
13759: ,x_org_id => fnd_global.org_id
13760: );
13761: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);
13762: COMMIT;
13763: --------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');

Line 14040: , x_created_by => fnd_global.user_id--p_lease_terms_rec.

14036: , x_project_attribute13 => p_lease_terms_rec.attribute13
14037: , x_project_attribute14 => p_lease_terms_rec.attribute14
14038: , x_project_attribute15 => p_lease_terms_rec.attribute15
14039: , x_creation_date => SYSDATE--p_lease_terms_rec.creation_date
14040: , x_created_by => fnd_global.user_id--p_lease_terms_rec.
14041: , x_last_update_date => SYSDATE --p_lease_terms_rec.
14042: , x_last_updated_by => fnd_global.user_id--p_lease_terms_rec.
14043: , x_last_update_login => fnd_global.login_id--p_lease_terms_rec.
14044: , x_calling_form => NULL

Line 14042: , x_last_updated_by => fnd_global.user_id--p_lease_terms_rec.

14038: , x_project_attribute15 => p_lease_terms_rec.attribute15
14039: , x_creation_date => SYSDATE--p_lease_terms_rec.creation_date
14040: , x_created_by => fnd_global.user_id--p_lease_terms_rec.
14041: , x_last_update_date => SYSDATE --p_lease_terms_rec.
14042: , x_last_updated_by => fnd_global.user_id--p_lease_terms_rec.
14043: , x_last_update_login => fnd_global.login_id--p_lease_terms_rec.
14044: , x_calling_form => NULL
14045: , x_org_id => g_org_id--p_lease_terms_rec.org_id--OOPS
14046: , x_lease_status => p_lease_terms_rec.lease_status

Line 14043: , x_last_update_login => fnd_global.login_id--p_lease_terms_rec.

14039: , x_creation_date => SYSDATE--p_lease_terms_rec.creation_date
14040: , x_created_by => fnd_global.user_id--p_lease_terms_rec.
14041: , x_last_update_date => SYSDATE --p_lease_terms_rec.
14042: , x_last_updated_by => fnd_global.user_id--p_lease_terms_rec.
14043: , x_last_update_login => fnd_global.login_id--p_lease_terms_rec.
14044: , x_calling_form => NULL
14045: , x_org_id => g_org_id--p_lease_terms_rec.org_id--OOPS
14046: , x_lease_status => p_lease_terms_rec.lease_status
14047: , x_recoverable_flag => p_lease_terms_rec.recoverable_flag

Line 15192: , p_resp_appl_id => fnd_global.resp_appl_id

15188: , p_desc_segment13 => p_payment_terms_tbl(i).attribute13
15189: , p_desc_segment14 => p_payment_terms_tbl(i).attribute14
15190: , p_desc_segment15 => p_payment_terms_tbl(i).attribute15
15191: , p_desc_context => p_payment_terms_tbl(i).attribute_category
15192: , p_resp_appl_id => fnd_global.resp_appl_id
15193: , p_resp_id => fnd_global.resp_id
15194: , p_return_status => x_return_status
15195: );
15196:

Line 15193: , p_resp_id => fnd_global.resp_id

15189: , p_desc_segment14 => p_payment_terms_tbl(i).attribute14
15190: , p_desc_segment15 => p_payment_terms_tbl(i).attribute15
15191: , p_desc_context => p_payment_terms_tbl(i).attribute_category
15192: , p_resp_appl_id => fnd_global.resp_appl_id
15193: , p_resp_id => fnd_global.resp_id
15194: , p_return_status => x_return_status
15195: );
15196:
15197: IF (x_return_status = fnd_api.g_ret_sts_error)

Line 15376: , p_resp_appl_id => fnd_global.resp_appl_id

15372: , p_desc_segment13 => p_payment_terms_tbl(i).project_attribute13
15373: , p_desc_segment14 => p_payment_terms_tbl(i).project_attribute14
15374: , p_desc_segment15 => p_payment_terms_tbl(i).project_attribute15
15375: , p_desc_context => p_payment_terms_tbl(i).project_attribute_category
15376: , p_resp_appl_id => fnd_global.resp_appl_id
15377: , p_resp_id => fnd_global.resp_id
15378: , p_return_status => x_return_status
15379: );
15380:

Line 15377: , p_resp_id => fnd_global.resp_id

15373: , p_desc_segment14 => p_payment_terms_tbl(i).project_attribute14
15374: , p_desc_segment15 => p_payment_terms_tbl(i).project_attribute15
15375: , p_desc_context => p_payment_terms_tbl(i).project_attribute_category
15376: , p_resp_appl_id => fnd_global.resp_appl_id
15377: , p_resp_id => fnd_global.resp_id
15378: , p_return_status => x_return_status
15379: );
15380:
15381: IF (x_return_status = fnd_api.g_ret_sts_error)

Line 16119: ,x_last_updated_by => fnd_global.user_id

16115: ,x_account_class => p_payment_terms_tbl(i).p_terms_exp_rev_accounts_tbl(m).account_code
16116: ,x_percentage => p_payment_terms_tbl(i).p_terms_exp_rev_accounts_tbl(m).account_percentage
16117: ,x_line_number => l_max_rownum
16118: ,x_last_update_date => SYSDATE
16119: ,x_last_updated_by => fnd_global.user_id
16120: ,x_creation_date => SYSDATE
16121: ,x_created_by => fnd_global.user_id
16122: ,x_last_update_login => fnd_global.login_id
16123: ,x_attribute_category => NULL

Line 16121: ,x_created_by => fnd_global.user_id

16117: ,x_line_number => l_max_rownum
16118: ,x_last_update_date => SYSDATE
16119: ,x_last_updated_by => fnd_global.user_id
16120: ,x_creation_date => SYSDATE
16121: ,x_created_by => fnd_global.user_id
16122: ,x_last_update_login => fnd_global.login_id
16123: ,x_attribute_category => NULL
16124: ,x_attribute1 => NULL
16125: ,x_attribute2 => NULL

Line 16122: ,x_last_update_login => fnd_global.login_id

16118: ,x_last_update_date => SYSDATE
16119: ,x_last_updated_by => fnd_global.user_id
16120: ,x_creation_date => SYSDATE
16121: ,x_created_by => fnd_global.user_id
16122: ,x_last_update_login => fnd_global.login_id
16123: ,x_attribute_category => NULL
16124: ,x_attribute1 => NULL
16125: ,x_attribute2 => NULL
16126: ,x_attribute3 => NULL

Line 16172: ,x_last_updated_by => fnd_global.user_id

16168: ,x_account_class => p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(m).account_code
16169: ,x_percentage => p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(m).account_percentage
16170: ,x_line_number => l_max_rownum
16171: ,x_last_update_date => SYSDATE
16172: ,x_last_updated_by => fnd_global.user_id
16173: ,x_creation_date => SYSDATE
16174: ,x_created_by => fnd_global.user_id
16175: ,x_last_update_login => fnd_global.login_id
16176: ,x_attribute_category => NULL

Line 16174: ,x_created_by => fnd_global.user_id

16170: ,x_line_number => l_max_rownum
16171: ,x_last_update_date => SYSDATE
16172: ,x_last_updated_by => fnd_global.user_id
16173: ,x_creation_date => SYSDATE
16174: ,x_created_by => fnd_global.user_id
16175: ,x_last_update_login => fnd_global.login_id
16176: ,x_attribute_category => NULL
16177: ,x_attribute1 => NULL
16178: ,x_attribute2 => NULL

Line 16175: ,x_last_update_login => fnd_global.login_id

16171: ,x_last_update_date => SYSDATE
16172: ,x_last_updated_by => fnd_global.user_id
16173: ,x_creation_date => SYSDATE
16174: ,x_created_by => fnd_global.user_id
16175: ,x_last_update_login => fnd_global.login_id
16176: ,x_attribute_category => NULL
16177: ,x_attribute1 => NULL
16178: ,x_attribute2 => NULL
16179: ,x_attribute3 => NULL

Line 16223: ,x_last_updated_by => fnd_global.user_id

16219: ,x_account_class => p_payment_terms_tbl(i).p_terms_accrual_account_tbl(m).account_code
16220: ,x_percentage => p_payment_terms_tbl(i).p_terms_accrual_account_tbl(m).account_percentage
16221: ,x_line_number => l_max_rownum
16222: ,x_last_update_date => SYSDATE
16223: ,x_last_updated_by => fnd_global.user_id
16224: ,x_creation_date => SYSDATE
16225: ,x_created_by => fnd_global.user_id
16226: ,x_last_update_login => fnd_global.login_id
16227: ,x_attribute_category => NULL

Line 16225: ,x_created_by => fnd_global.user_id

16221: ,x_line_number => l_max_rownum
16222: ,x_last_update_date => SYSDATE
16223: ,x_last_updated_by => fnd_global.user_id
16224: ,x_creation_date => SYSDATE
16225: ,x_created_by => fnd_global.user_id
16226: ,x_last_update_login => fnd_global.login_id
16227: ,x_attribute_category => NULL
16228: ,x_attribute1 => NULL
16229: ,x_attribute2 => NULL

Line 16226: ,x_last_update_login => fnd_global.login_id

16222: ,x_last_update_date => SYSDATE
16223: ,x_last_updated_by => fnd_global.user_id
16224: ,x_creation_date => SYSDATE
16225: ,x_created_by => fnd_global.user_id
16226: ,x_last_update_login => fnd_global.login_id
16227: ,x_attribute_category => NULL
16228: ,x_attribute1 => NULL
16229: ,x_attribute2 => NULL
16230: ,x_attribute3 => NULL

Line 16319: ,x_last_updated_by => fnd_global.user_id

16315: ,x_account_class => l_acc_code
16316: ,x_percentage => p_payment_terms_tbl(i).p_terms_exp_rev_accounts_tbl(p).account_percentage
16317: ,x_line_number => r_dist_details.line_number
16318: ,x_last_update_date => SYSDATE
16319: ,x_last_updated_by => fnd_global.user_id
16320: ,x_last_update_login => fnd_global.login_id
16321: ,x_attribute_category => r_dist_details.attribute_category
16322: ,x_attribute1 => r_dist_details.attribute1
16323: ,x_attribute2 => r_dist_details.attribute2

Line 16320: ,x_last_update_login => fnd_global.login_id

16316: ,x_percentage => p_payment_terms_tbl(i).p_terms_exp_rev_accounts_tbl(p).account_percentage
16317: ,x_line_number => r_dist_details.line_number
16318: ,x_last_update_date => SYSDATE
16319: ,x_last_updated_by => fnd_global.user_id
16320: ,x_last_update_login => fnd_global.login_id
16321: ,x_attribute_category => r_dist_details.attribute_category
16322: ,x_attribute1 => r_dist_details.attribute1
16323: ,x_attribute2 => r_dist_details.attribute2
16324: ,x_attribute3 => r_dist_details.attribute3

Line 16360: ,x_last_updated_by => fnd_global.user_id

16356: ,x_account_class => l_acc_code
16357: ,x_percentage => p_payment_terms_tbl(i).p_terms_exp_rev_accounts_tbl(p).account_percentage
16358: ,x_line_number => l_max_rownum
16359: ,x_last_update_date => SYSDATE
16360: ,x_last_updated_by => fnd_global.user_id
16361: ,x_creation_date => SYSDATE
16362: ,x_created_by => fnd_global.user_id
16363: ,x_last_update_login => fnd_global.login_id
16364: ,x_attribute_category => NULL

Line 16362: ,x_created_by => fnd_global.user_id

16358: ,x_line_number => l_max_rownum
16359: ,x_last_update_date => SYSDATE
16360: ,x_last_updated_by => fnd_global.user_id
16361: ,x_creation_date => SYSDATE
16362: ,x_created_by => fnd_global.user_id
16363: ,x_last_update_login => fnd_global.login_id
16364: ,x_attribute_category => NULL
16365: ,x_attribute1 => NULL
16366: ,x_attribute2 => NULL

Line 16363: ,x_last_update_login => fnd_global.login_id

16359: ,x_last_update_date => SYSDATE
16360: ,x_last_updated_by => fnd_global.user_id
16361: ,x_creation_date => SYSDATE
16362: ,x_created_by => fnd_global.user_id
16363: ,x_last_update_login => fnd_global.login_id
16364: ,x_attribute_category => NULL
16365: ,x_attribute1 => NULL
16366: ,x_attribute2 => NULL
16367: ,x_attribute3 => NULL

Line 16380: ,x_org_id => g_org_id--fnd_global.org_id

16376: ,x_attribute12 => NULL
16377: ,x_attribute13 => NULL
16378: ,x_attribute14 => NULL
16379: ,x_attribute15 => NULL
16380: ,x_org_id => g_org_id--fnd_global.org_id
16381: );
16382: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.INSERT_ROW for Expense Revenue Successful',3);
16383:
16384: EXCEPTION

Line 16427: ,x_last_updated_by => fnd_global.user_id

16423: ,x_account_class => l_acc_code
16424: ,x_percentage => p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(p).account_percentage
16425: ,x_line_number => r_dist_details.line_number
16426: ,x_last_update_date => SYSDATE
16427: ,x_last_updated_by => fnd_global.user_id
16428: ,x_last_update_login => fnd_global.login_id
16429: ,x_attribute_category => r_dist_details.attribute_category
16430: ,x_attribute1 => r_dist_details.attribute1
16431: ,x_attribute2 => r_dist_details.attribute2

Line 16428: ,x_last_update_login => fnd_global.login_id

16424: ,x_percentage => p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(p).account_percentage
16425: ,x_line_number => r_dist_details.line_number
16426: ,x_last_update_date => SYSDATE
16427: ,x_last_updated_by => fnd_global.user_id
16428: ,x_last_update_login => fnd_global.login_id
16429: ,x_attribute_category => r_dist_details.attribute_category
16430: ,x_attribute1 => r_dist_details.attribute1
16431: ,x_attribute2 => r_dist_details.attribute2
16432: ,x_attribute3 => r_dist_details.attribute3

Line 16496: ,x_last_updated_by => fnd_global.user_id

16492: ,x_account_class => p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(p).account_code
16493: ,x_percentage => p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(p).account_percentage
16494: ,x_line_number => l_max_rownum
16495: ,x_last_update_date => SYSDATE
16496: ,x_last_updated_by => fnd_global.user_id
16497: ,x_creation_date => SYSDATE
16498: ,x_created_by => fnd_global.user_id
16499: ,x_last_update_login => fnd_global.login_id
16500: ,x_attribute_category => NULL

Line 16498: ,x_created_by => fnd_global.user_id

16494: ,x_line_number => l_max_rownum
16495: ,x_last_update_date => SYSDATE
16496: ,x_last_updated_by => fnd_global.user_id
16497: ,x_creation_date => SYSDATE
16498: ,x_created_by => fnd_global.user_id
16499: ,x_last_update_login => fnd_global.login_id
16500: ,x_attribute_category => NULL
16501: ,x_attribute1 => NULL
16502: ,x_attribute2 => NULL

Line 16499: ,x_last_update_login => fnd_global.login_id

16495: ,x_last_update_date => SYSDATE
16496: ,x_last_updated_by => fnd_global.user_id
16497: ,x_creation_date => SYSDATE
16498: ,x_created_by => fnd_global.user_id
16499: ,x_last_update_login => fnd_global.login_id
16500: ,x_attribute_category => NULL
16501: ,x_attribute1 => NULL
16502: ,x_attribute2 => NULL
16503: ,x_attribute3 => NULL

Line 16570: ,x_last_updated_by => fnd_global.user_id

16566: ,x_account_class => l_acc_code
16567: ,x_percentage => p_payment_terms_tbl(i).p_terms_accrual_account_tbl(p).account_percentage
16568: ,x_line_number => r_dist_details.line_number
16569: ,x_last_update_date => SYSDATE
16570: ,x_last_updated_by => fnd_global.user_id
16571: ,x_last_update_login => fnd_global.login_id
16572: ,x_attribute_category => r_dist_details.attribute_category
16573: ,x_attribute1 => r_dist_details.attribute1
16574: ,x_attribute2 => r_dist_details.attribute2

Line 16571: ,x_last_update_login => fnd_global.login_id

16567: ,x_percentage => p_payment_terms_tbl(i).p_terms_accrual_account_tbl(p).account_percentage
16568: ,x_line_number => r_dist_details.line_number
16569: ,x_last_update_date => SYSDATE
16570: ,x_last_updated_by => fnd_global.user_id
16571: ,x_last_update_login => fnd_global.login_id
16572: ,x_attribute_category => r_dist_details.attribute_category
16573: ,x_attribute1 => r_dist_details.attribute1
16574: ,x_attribute2 => r_dist_details.attribute2
16575: ,x_attribute3 => r_dist_details.attribute3

Line 16630: ,x_last_updated_by => fnd_global.user_id

16626: ,x_account_class => p_payment_terms_tbl(i).p_terms_accrual_account_tbl(p).account_code
16627: ,x_percentage => p_payment_terms_tbl(i).p_terms_accrual_account_tbl(p).account_percentage
16628: ,x_line_number => l_max_rownum
16629: ,x_last_update_date => SYSDATE
16630: ,x_last_updated_by => fnd_global.user_id
16631: ,x_creation_date => SYSDATE
16632: ,x_created_by => fnd_global.user_id
16633: ,x_last_update_login => fnd_global.login_id
16634: ,x_attribute_category => NULL

Line 16632: ,x_created_by => fnd_global.user_id

16628: ,x_line_number => l_max_rownum
16629: ,x_last_update_date => SYSDATE
16630: ,x_last_updated_by => fnd_global.user_id
16631: ,x_creation_date => SYSDATE
16632: ,x_created_by => fnd_global.user_id
16633: ,x_last_update_login => fnd_global.login_id
16634: ,x_attribute_category => NULL
16635: ,x_attribute1 => NULL
16636: ,x_attribute2 => NULL

Line 16633: ,x_last_update_login => fnd_global.login_id

16629: ,x_last_update_date => SYSDATE
16630: ,x_last_updated_by => fnd_global.user_id
16631: ,x_creation_date => SYSDATE
16632: ,x_created_by => fnd_global.user_id
16633: ,x_last_update_login => fnd_global.login_id
16634: ,x_attribute_category => NULL
16635: ,x_attribute1 => NULL
16636: ,x_attribute2 => NULL
16637: ,x_attribute3 => NULL