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