2128: commitment_id = NULL,
2129: object_version_number = object_version_number +
2130: 1,
2131: last_update_date = SYSDATE,
2132: last_updated_by = fnd_global.user_id,
2133: last_update_login = fnd_global.login_id
2134: WHERE chr_id = p_chr_id;
2135:
2136: UPDATE okc_k_headers_all_b
2129: object_version_number = object_version_number +
2130: 1,
2131: last_update_date = SYSDATE,
2132: last_updated_by = fnd_global.user_id,
2133: last_update_login = fnd_global.login_id
2134: WHERE chr_id = p_chr_id;
2135:
2136: UPDATE okc_k_headers_all_b
2137: SET cust_po_number = NULL,
2141: NVL (x_rnrl_rec.payment_terms_id1, payment_term_id),
2142: object_version_number = object_version_number +
2143: 1,
2144: last_update_date = SYSDATE,
2145: last_updated_by = fnd_global.user_id,
2146: last_update_login = fnd_global.login_id
2147: WHERE ID = p_chr_id;
2148: ELSIF p_payment_type = 'COM' THEN
2149: UPDATE oks_k_headers_b
2142: object_version_number = object_version_number +
2143: 1,
2144: last_update_date = SYSDATE,
2145: last_updated_by = fnd_global.user_id,
2146: last_update_login = fnd_global.login_id
2147: WHERE ID = p_chr_id;
2148: ELSIF p_payment_type = 'COM' THEN
2149: UPDATE oks_k_headers_b
2150: SET payment_type = p_payment_type,
2152: trxn_extension_id = NULL,
2153: object_version_number = object_version_number +
2154: 1,
2155: last_update_date = SYSDATE,
2156: last_updated_by = fnd_global.user_id,
2157: last_update_login = fnd_global.login_id
2158: WHERE chr_id = p_chr_id;
2159:
2160: UPDATE okc_k_headers_all_b
2153: object_version_number = object_version_number +
2154: 1,
2155: last_update_date = SYSDATE,
2156: last_updated_by = fnd_global.user_id,
2157: last_update_login = fnd_global.login_id
2158: WHERE chr_id = p_chr_id;
2159:
2160: UPDATE okc_k_headers_all_b
2161: SET cust_po_number = NULL,
2163: cust_po_number_req_yn = 'N',
2164: object_version_number = object_version_number +
2165: 1,
2166: last_update_date = SYSDATE,
2167: last_updated_by = fnd_global.user_id,
2168: last_update_login = fnd_global.login_id
2169: WHERE ID = p_chr_id;
2170: ELSE
2171: UPDATE oks_k_headers_b
2164: object_version_number = object_version_number +
2165: 1,
2166: last_update_date = SYSDATE,
2167: last_updated_by = fnd_global.user_id,
2168: last_update_login = fnd_global.login_id
2169: WHERE ID = p_chr_id;
2170: ELSE
2171: UPDATE oks_k_headers_b
2172: SET payment_type = NULL,
2174: commitment_id = NULL,
2175: object_version_number = object_version_number +
2176: 1,
2177: last_update_date = SYSDATE,
2178: last_updated_by = fnd_global.user_id,
2179: last_update_login = fnd_global.login_id
2180: WHERE chr_id = p_chr_id;
2181:
2182: UPDATE okc_k_headers_all_b
2175: object_version_number = object_version_number +
2176: 1,
2177: last_update_date = SYSDATE,
2178: last_updated_by = fnd_global.user_id,
2179: last_update_login = fnd_global.login_id
2180: WHERE chr_id = p_chr_id;
2181:
2182: UPDATE okc_k_headers_all_b
2183: SET cust_po_number = p_payment_details,
2184: payment_instruction_type = p_payment_type,
2185: object_version_number = object_version_number +
2186: 1,
2187: last_update_date = SYSDATE,
2188: last_updated_by = fnd_global.user_id,
2189: last_update_login = fnd_global.login_id
2190: WHERE ID = p_chr_id;
2191: END IF;
2192:
2185: object_version_number = object_version_number +
2186: 1,
2187: last_update_date = SYSDATE,
2188: last_updated_by = fnd_global.user_id,
2189: last_update_login = fnd_global.login_id
2190: WHERE ID = p_chr_id;
2191: END IF;
2192:
2193: -- bump up the minor version number
2196: 1,
2197: object_version_number = object_version_number +
2198: 1,
2199: last_update_date = SYSDATE,
2200: last_updated_by = fnd_global.user_id,
2201: last_update_login = fnd_global.login_id
2202: WHERE chr_id = p_chr_id;
2203:
2204: -- Standard call to get message count and if count is 1, get message info.
2197: object_version_number = object_version_number +
2198: 1,
2199: last_update_date = SYSDATE,
2200: last_updated_by = fnd_global.user_id,
2201: last_update_login = fnd_global.login_id
2202: WHERE chr_id = p_chr_id;
2203:
2204: -- Standard call to get message count and if count is 1, get message info.
2205: fnd_msg_pub.count_and_get (p_encoded => 'F',