660:
661: G_stage := 'pa_interface_utils_pub.set_global_info';
662:
663: /* pa_interface_utils_pub.set_global_info(p_api_version_number => 1.0,
664: p_responsibility_id => FND_GLOBAL.resp_id,
665: p_user_id => FND_GLOBAL.user_id,
666: p_resp_appl_id => FND_GLOBAL.resp_appl_id, -- Bug 2534915
667: p_msg_count => x_msg_count,
668: p_msg_data =>x_msg_data,
661: G_stage := 'pa_interface_utils_pub.set_global_info';
662:
663: /* pa_interface_utils_pub.set_global_info(p_api_version_number => 1.0,
664: p_responsibility_id => FND_GLOBAL.resp_id,
665: p_user_id => FND_GLOBAL.user_id,
666: p_resp_appl_id => FND_GLOBAL.resp_appl_id, -- Bug 2534915
667: p_msg_count => x_msg_count,
668: p_msg_data =>x_msg_data,
669: p_return_status => x_return_status);
662:
663: /* pa_interface_utils_pub.set_global_info(p_api_version_number => 1.0,
664: p_responsibility_id => FND_GLOBAL.resp_id,
665: p_user_id => FND_GLOBAL.user_id,
666: p_resp_appl_id => FND_GLOBAL.resp_appl_id, -- Bug 2534915
667: p_msg_count => x_msg_count,
668: p_msg_data =>x_msg_data,
669: p_return_status => x_return_status);
670:
2040: select
2041: x_award_project_id,
2042: option_code,
2043: SYSDATE,
2044: fnd_global.user_id,
2045: SYSDATE ,
2046: fnd_global.user_id,
2047: fnd_global.login_id
2048: from pa_options
2042: option_code,
2043: SYSDATE,
2044: fnd_global.user_id,
2045: SYSDATE ,
2046: fnd_global.user_id,
2047: fnd_global.login_id
2048: from pa_options
2049: where option_code not in ( 'STRUCTURES', 'STRUCTURES_SS' );
2050:
2043: SYSDATE,
2044: fnd_global.user_id,
2045: SYSDATE ,
2046: fnd_global.user_id,
2047: fnd_global.login_id
2048: from pa_options
2049: where option_code not in ( 'STRUCTURES', 'STRUCTURES_SS' );
2050:
2051: -- Create structure for the award project template's task.
2303: segment1 = g_award_rec.award_number,
2304: billing_cycle_id = g_award_rec.Billing_Cycle_Id,
2305: billing_offset = NVL(g_award_rec.Billing_Offset,0) ,
2306: last_update_date = sysdate,
2307: last_updated_by = fnd_global.user_id,
2308: last_update_login = fnd_global.login_id
2309: where project_id = g_award_rec.award_project_id ;
2310:
2311: --
2304: billing_cycle_id = g_award_rec.Billing_Cycle_Id,
2305: billing_offset = NVL(g_award_rec.Billing_Offset,0) ,
2306: last_update_date = sysdate,
2307: last_updated_by = fnd_global.user_id,
2308: last_update_login = fnd_global.login_id
2309: where project_id = g_award_rec.award_project_id ;
2310:
2311: --
2312: -- Update project customers.
2315: update PA_PROJECT_Customers
2316: set BILL_TO_ADDRESS_ID = NVL(g_award_rec.bill_To_Address_Id, bill_TO_ADDRESS_ID ),
2317: SHIP_TO_ADDRESS_ID = NVL(g_award_rec.Ship_To_Address_Id, SHIP_TO_ADDRESS_ID )
2318: ,LAST_UPDATE_DATE = SYSDATE
2319: ,LAST_UPDATED_BY = fnd_global.user_id
2320: ,LAST_UPDATE_LOGIN = fnd_global.login_id
2321: where project_id = g_award_rec.award_project_id
2322: and customer_id = L_Project_IN_REC.CUSTOMER_ID ;
2323:
2316: set BILL_TO_ADDRESS_ID = NVL(g_award_rec.bill_To_Address_Id, bill_TO_ADDRESS_ID ),
2317: SHIP_TO_ADDRESS_ID = NVL(g_award_rec.Ship_To_Address_Id, SHIP_TO_ADDRESS_ID )
2318: ,LAST_UPDATE_DATE = SYSDATE
2319: ,LAST_UPDATED_BY = fnd_global.user_id
2320: ,LAST_UPDATE_LOGIN = fnd_global.login_id
2321: where project_id = g_award_rec.award_project_id
2322: and customer_id = L_Project_IN_REC.CUSTOMER_ID ;
2323:
2324: END CREATE_AWARD_PROJECT;
4538: 'BILLING', (G_contact_rec.Contact_id),
4539: 'SHIPPING',(G_contact_rec.Contact_id),
4540: contact_id ),
4541: last_update_date = SYSDATE,
4542: last_updated_by = fnd_global.user_id,
4543: last_update_login = fnd_global.login_id
4544: WHERE project_id = l_award_project_id
4545: AND customer_id = G_contact_rec.customer_id;
4546: END IF;
4539: 'SHIPPING',(G_contact_rec.Contact_id),
4540: contact_id ),
4541: last_update_date = SYSDATE,
4542: last_updated_by = fnd_global.user_id,
4543: last_update_login = fnd_global.login_id
4544: WHERE project_id = l_award_project_id
4545: AND customer_id = G_contact_rec.customer_id;
4546: END IF;
4547: END IF;
5235:
5236: G_stage := 'pa_interface_utils_pub.set_global_info';
5237:
5238: pa_interface_utils_pub.set_global_info(p_api_version_number => 1.0,
5239: p_responsibility_id => FND_GLOBAL.resp_id,
5240: p_user_id => FND_GLOBAL.user_id,
5241: p_resp_appl_id => FND_GLOBAL.resp_appl_id, -- Bug 2534915
5242: p_msg_count => x_msg_count,
5243: p_msg_data =>x_msg_data,
5236: G_stage := 'pa_interface_utils_pub.set_global_info';
5237:
5238: pa_interface_utils_pub.set_global_info(p_api_version_number => 1.0,
5239: p_responsibility_id => FND_GLOBAL.resp_id,
5240: p_user_id => FND_GLOBAL.user_id,
5241: p_resp_appl_id => FND_GLOBAL.resp_appl_id, -- Bug 2534915
5242: p_msg_count => x_msg_count,
5243: p_msg_data =>x_msg_data,
5244: p_return_status => x_return_status);
5237:
5238: pa_interface_utils_pub.set_global_info(p_api_version_number => 1.0,
5239: p_responsibility_id => FND_GLOBAL.resp_id,
5240: p_user_id => FND_GLOBAL.user_id,
5241: p_resp_appl_id => FND_GLOBAL.resp_appl_id, -- Bug 2534915
5242: p_msg_count => x_msg_count,
5243: p_msg_data =>x_msg_data,
5244: p_return_status => x_return_status);
5245: