9542: OTM passes the key-value pair in a VARRAY (cct_keyvalue_varr)
9543: ********************************************/
9544:
9545: PROCEDURE csc_prof_jit ( p_key_value_varr IN cct_keyvalue_varr,
9546: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9547: p_critical_flag IN VARCHAR2 DEFAULT NULL,
9548: x_return_status OUT NOCOPY VARCHAR2,
9549: x_msg_count OUT NOCOPY NUMBER,
9550: x_msg_data OUT NOCOPY VARCHAR2
9631: FROM csc_hz_parties_rel_v
9632: WHERE rel_party_id = l_party_id;
9633:
9634: BEGIN
9635: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9636: FND_MSG_PUB.initialize;
9637: END IF;
9638: x_return_status := FND_API.G_RET_STS_SUCCESS;
9639: /* get values from varray parameter p_key_value_varr */
9634: BEGIN
9635: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9636: FND_MSG_PUB.initialize;
9637: END IF;
9638: x_return_status := FND_API.G_RET_STS_SUCCESS;
9639: /* get values from varray parameter p_key_value_varr */
9640: l_media_item_id := CCT_COLLECTION_UTIL_PUB.Get
9641: ( p_key_value_varr => p_key_value_varr,
9642: p_key => 'occtMediaItemID',
10214: ( p_status => l_jit_err_status,
10215: p_err_code => l_sql_code,
10216: p_media_item_id => l_media_item_id );
10217:
10218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10219:
10220: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10221: FND_MSG_PUB.Add_Exc_Msg
10222: ( p_pkg_name => G_PKG_NAME,