APPS.OKS_IBINT_PUB dependencies on OKS_BATCH_RULES

Line 2654: DELETE FROM OKS_BATCH_RULES

2650:
2651: Begin
2652:
2653: x_return_status := 'S';
2654: DELETE FROM OKS_BATCH_RULES
2655: WHERE batch_ID = P_Batch_ID;
2656: Exception
2657: When Others Then
2658: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2683: FROM oks_batch_rules

2679: IS
2680:
2681: Cursor l_check_csr IS
2682: SELECT 'x'
2683: FROM oks_batch_rules
2684: WHERE batch_id = p_batch_id
2685: AND NVL(new_account_id, p_new_owner_id) = p_new_owner_id;
2686:
2687: l_dummy_var VARCHAR2(1) := '?';

Line 2703: OKC_API.set_message(G_APP_NAME, 'OKS_BATCH_RULES_MISMATCH');

2699: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2700: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
2701: 'Accounts mismatch ' ||p_batch_id ||'Account id'|| p_new_owner_id );
2702: END IF;
2703: OKC_API.set_message(G_APP_NAME, 'OKS_BATCH_RULES_MISMATCH');
2704: END IF;
2705: ELSE
2706: IF p_batch_id IS NOT NULL
2707: THEN

Line 2740: l_batch_rule oks_brl_pvt.oks_batch_rules_v_rec_type;

2736: x_return_status OUT NOCOPY VARCHAR2,
2737: x_msg_count OUT NOCOPY NUMBER,
2738: x_msg_data OUT NOCOPY VARCHAR2)
2739: Is
2740: l_batch_rule oks_brl_pvt.oks_batch_rules_v_rec_type;
2741: x_batch_rule oks_brl_pvt.oks_batch_rules_v_rec_type;
2742: l_reason_type VARCHAR2(3);
2743: l_return_status VARCHAR2(1) := 'S';
2744: begin

Line 2741: x_batch_rule oks_brl_pvt.oks_batch_rules_v_rec_type;

2737: x_msg_count OUT NOCOPY NUMBER,
2738: x_msg_data OUT NOCOPY VARCHAR2)
2739: Is
2740: l_batch_rule oks_brl_pvt.oks_batch_rules_v_rec_type;
2741: x_batch_rule oks_brl_pvt.oks_batch_rules_v_rec_type;
2742: l_reason_type VARCHAR2(3);
2743: l_return_status VARCHAR2(1) := 'S';
2744: begin
2745:

Line 2781: p_oks_batch_rules_v_rec => l_batch_rule,

2777: p_init_msg_list => p_init_msg_list,
2778: x_return_status => l_return_status,
2779: x_msg_count => x_msg_count,
2780: x_msg_data => x_msg_data,
2781: p_oks_batch_rules_v_rec => l_batch_rule,
2782: x_oks_batch_rules_v_rec => x_batch_rule);
2783:
2784: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2785: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.CREATE_BATCH',

Line 2782: x_oks_batch_rules_v_rec => x_batch_rule);

2778: x_return_status => l_return_status,
2779: x_msg_count => x_msg_count,
2780: x_msg_data => x_msg_data,
2781: p_oks_batch_rules_v_rec => l_batch_rule,
2782: x_oks_batch_rules_v_rec => x_batch_rule);
2783:
2784: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2785: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.CREATE_BATCH',
2786: 'oks_brl_pvt.insert_row(Return status = '|| l_return_status || ')');