DBA Data[Home] [Help]

APPS.OKL_ACN_PVT dependencies on OKL_ASSET_CNDTNS

Line 657: select 'x' FROM OKL_ASSET_CNDTNS

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

Line 692: p_token3_value => 'OKL_ASSET_CNDTNS');

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;

Line 920: p_token2_value => 'OKL_ASSET_CNDTNS_V',

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

Line 1053: p_token2_value => 'OKL_ASSET_CNDTNS_V',

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

Line 1123: p_token2_value => 'OKL_ASSET_CNDTNS_V',

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