653: l_dummy_var VARCHAR2(1) := '?';
654:
655: -- select the ID of the parent record from the parent table
656: CURSOR l_acnv_csr IS
657: select 'x' FROM OKL_ASSET_CNDTNS
658: where ID = p_acnv_rec.acd_id;
659:
660: begin
661: -- initialize return status
688: p_token1_value => 'acd_id',
689: p_token2 => G_CHILD_TABLE_TOKEN,
690: p_token2_value => 'OKL_ASSET_CNDTN_LNS_V',
691: p_token3 => G_PARENT_TABLE_TOKEN,
692: p_token3_value => 'OKL_ASSET_CNDTNS');
693:
694: -- notify caller of an error
695: x_return_status := OKC_API.G_RET_STS_ERROR;
696: END IF;
916: p_msg_name => G_NO_PARENT_RECORD,
917: p_token1 => G_COL_NAME_TOKEN,
918: p_token1_value => 'isq_id',
919: p_token2 => G_CHILD_TABLE_TOKEN,
920: p_token2_value => 'OKL_ASSET_CNDTNS_V',
921: p_token3 => G_PARENT_TABLE_TOKEN,
922: p_token3_value => 'OKX_SRVC_REQUESTS_V');
923:
924: -- notify caller of an error
1049: p_msg_name => G_NO_PARENT_RECORD,
1050: p_token1 => G_COL_NAME_TOKEN,
1051: p_token1_value => 'pzt_id',
1052: p_token2 => G_CHILD_TABLE_TOKEN,
1053: p_token2_value => 'OKL_ASSET_CNDTNS_V',
1054: p_token3 => G_PARENT_TABLE_TOKEN,
1055: p_token3_value => 'OKX_PARTS_V');
1056:
1057: -- notify caller of an error
1119: p_msg_name => G_NO_PARENT_RECORD,
1120: p_token1 => G_COL_NAME_TOKEN,
1121: p_token1_value => 'rpc_id',
1122: p_token2 => G_CHILD_TABLE_TOKEN,
1123: p_token2_value => 'OKL_ASSET_CNDTNS_V',
1124: p_token3 => G_PARENT_TABLE_TOKEN,
1125: p_token3_value => 'OKL_REPAIR_COSTS_V');
1126:
1127: -- notify caller of an error