DBA Data[Home] [Help]

APPS.QP_QUALIFIERS_UTIL dependencies on QP_DELAYED_REQUESTS_PVT

Line 3212: qp_delayed_requests_PVT.log_request(

3208:
3209: IF NOT (l_list_type_code = 'PRL' and p_QUALIFIERS_rec.qualifier_context='MODLIST'
3210: and p_QUALIFIERS_rec.qualifier_attribute='QUALIFIER_ATTRIBUTE4') THEN
3211:
3212: qp_delayed_requests_PVT.log_request(
3213: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3214: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3215: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3216: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,

Line 3225: qp_delayed_requests_PVT.log_request(

3221: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3222:
3223: oe_debug_pub.add('log delayed request------------');
3224:
3225: qp_delayed_requests_PVT.log_request(
3226: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3227: p_param1 => p_QUALIFIERS_rec.list_header_id,
3228: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3229: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,

Line 3245: qp_delayed_requests_PVT.log_request(

3241: (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3242: p_QUALIFIERS_rec.list_line_id <> -1 AND
3243: l_llq_count = 1)
3244: THEN
3245: qp_delayed_requests_PVT.log_request(
3246: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3247: p_entity_id => p_QUALIFIERS_rec.list_line_id,
3248: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3249: p_requesting_entity_id => p_QUALIFIERS_rec.list_line_id,

Line 3255: qp_delayed_requests_PVT.log_request(

3251: x_return_status => l_return_status);
3252:
3253: -- mkarya for bug1769955 - log the MAINTAIN_LIST_HEADER_PHASES request for line qualifier
3254: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3255: qp_delayed_requests_PVT.log_request(
3256: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3257: p_param1 => p_QUALIFIERS_rec.list_header_id,
3258: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3259: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,

Line 3288: qp_delayed_requests_PVT.log_request(

3284: QP_GLOBALS.G_OPR_UPDATE,
3285: QP_GLOBALS.G_OPR_DELETE) THEN
3286: IF (l_list_type_code in ('PRL','AGR')) OR ((l_list_type_code NOT IN ('PRL','AGR')) AND (l_denormalize_qual= 'Y')) then --7120399
3287:
3288: qp_delayed_requests_PVT.log_request(
3289: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3290: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3291: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3292: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,

Line 3297: qp_delayed_requests_PVT.log_request(

3293: p_request_type => QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS,
3294: x_return_status => l_return_status);
3295: END IF;
3296: --Added following delayed request for Attributes Manager
3297: qp_delayed_requests_PVT.log_request(
3298: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3299: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3300: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3301: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,

Line 3314: qp_delayed_requests_PVT.log_request(

3310: (QP_GLOBALS.G_OPR_CREATE, QP_GLOBALS.G_OPR_UPDATE)) THEN
3311:
3312: oe_debug_pub.add('log delayed request--------warn_same_qual_grp');
3313:
3314: qp_delayed_requests_PVT.log_request(
3315: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3316: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3317: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3318: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,

Line 3355: qp_delayed_requests_PVT.log_request(

3351: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3352: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3353: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3354: oe_debug_pub.add('qualifier_grouping_no = ' || p_qualifiers_rec.qualifier_grouping_no);
3355: qp_delayed_requests_PVT.log_request(
3356: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3357: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3358: p_request_unique_key2 => p_qualifiers_rec.qualifier_grouping_no,
3359: p_entity_id => p_qualifiers_rec.list_line_id,

Line 3370: qp_delayed_requests_PVT.log_request(

3366: -- Log a delayed request to validate that if header level qualifier exist then at least
3367: -- one qualifier should exist for any existence of modifier line of modifier level
3368: -- 'LINE' or 'ORDER'
3369: if p_qualifiers_rec.list_line_id = -1 then
3370: qp_delayed_requests_PVT.log_request(
3371: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3372: p_entity_id => l_qualifiers_rec.list_header_id,
3373: p_request_unique_key1 => -1,
3374: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,

Line 3399: qp_delayed_requests_PVT.log_request(

3395: oe_debug_pub.add('In LOOP - update of qualifier grp to -1');
3396: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3397: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3398: oe_debug_pub.add('qualifier_grouping_no = ' || l_rec.qualifier_grouping_no);
3399: qp_delayed_requests_PVT.log_request(
3400: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3401: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3402: p_request_unique_key2 => l_rec.qualifier_grouping_no,
3403: p_entity_id => p_qualifiers_rec.list_line_id,

Line 3427: qp_delayed_requests_pvt.log_request(

3423: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3424: p_QUALIFIERS_rec.list_line_id = -1 THEN
3425: -- header qualifier is added to price list/modifier
3426: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3427: qp_delayed_requests_pvt.log_request(
3428: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3429: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3430: p_request_unique_key1 => NULL,
3431: p_request_unique_key2 => 'I',

Line 3437: qp_delayed_requests_pvt.log_request(

3433: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3434: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3435: x_return_status => l_return_status);
3436: ELSE
3437: qp_delayed_requests_pvt.log_request(
3438: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3439: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3440: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3441: p_request_unique_key2 => 'I',

Line 3456: qp_delayed_requests_pvt.log_request(

3452: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3453: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3454: -- updated other than qualifier grouping number
3455: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3456: qp_delayed_requests_pvt.log_request(
3457: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3458: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3459: p_request_unique_key1 => NULL,
3460: p_request_unique_key2 => 'U',

Line 3466: qp_delayed_requests_pvt.log_request(

3462: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3463: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3464: x_return_status => l_return_status);
3465: ELSE
3466: qp_delayed_requests_pvt.log_request(
3467: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3468: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3469: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3470: p_request_unique_key2 => 'U',

Line 3481: qp_delayed_requests_pvt.log_request(

3477: ELSE
3478: -- qualifier grouping number is modified
3479: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3480: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1) THEN
3481: qp_delayed_requests_pvt.log_request(
3482: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3483: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3484: p_request_unique_key1 => NULL,
3485: p_request_unique_key2 => 'U',

Line 3491: qp_delayed_requests_pvt.log_request(

3487: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3488: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3489: x_return_status => l_return_status);
3490: ELSE
3491: qp_delayed_requests_pvt.log_request(
3492: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3493: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3494: p_request_unique_key1 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3495: p_request_unique_key2 => 'U',

Line 3500: qp_delayed_requests_pvt.log_request(

3496: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3497: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3498: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3499: x_return_status => l_return_status);
3500: qp_delayed_requests_pvt.log_request(
3501: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3502: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3503: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3504: p_request_unique_key2 => 'U',

Line 3517: qp_delayed_requests_pvt.log_request(

3513:
3514: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3515: p_QUALIFIERS_rec.list_line_id = -1 THEN
3516: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 then
3517: qp_delayed_requests_pvt.log_request(
3518: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3519: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3520: p_request_unique_key1 => NULL,
3521: p_request_unique_key2 => 'D',

Line 3527: qp_delayed_requests_pvt.log_request(

3523: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3524: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3525: x_return_status => l_return_status);
3526: ELSE
3527: qp_delayed_requests_pvt.log_request(
3528: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3529: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3530: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3531: p_request_unique_key2 => 'D',

Line 3543: qp_delayed_requests_pvt.log_request(

3539: -- line pattern
3540: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3541: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3542: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3543: qp_delayed_requests_pvt.log_request(
3544: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3545: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3546: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3547: p_request_unique_key2 => NULL,

Line 3554: qp_delayed_requests_pvt.log_request(

3550: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3551: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3552: x_return_status => l_return_status);
3553: ELSE
3554: qp_delayed_requests_pvt.log_request(
3555: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3556: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3557: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3558: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,

Line 3572: qp_delayed_requests_pvt.log_request(

3568: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3569: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3570: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3571: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3572: qp_delayed_requests_pvt.log_request(
3573: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3574: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3575: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3576: p_request_unique_key2 => NULL,

Line 3583: qp_delayed_requests_pvt.log_request(

3579: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3580: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3581: x_return_status => l_return_status);
3582: ELSE
3583: qp_delayed_requests_pvt.log_request(
3584: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3585: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3586: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3587: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,

Line 3598: qp_delayed_requests_pvt.log_request(

3594:
3595: ELSE
3596: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3597: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1) THEN
3598: qp_delayed_requests_pvt.log_request(
3599: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3600: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3601: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3602: p_request_unique_key2 => NULL,

Line 3609: qp_delayed_requests_pvt.log_request(

3605: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3606: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3607: x_return_status => l_return_status);
3608: ELSE
3609: qp_delayed_requests_pvt.log_request(
3610: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3611: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3612: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3613: p_request_unique_key2 => p_old_QUALIFIERS_rec.qualifier_grouping_no,

Line 3619: qp_delayed_requests_pvt.log_request(

3615: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3616: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3617: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3618: x_return_status => l_return_status);
3619: qp_delayed_requests_pvt.log_request(
3620: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3621: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3622: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3623: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,

Line 3637: qp_delayed_requests_pvt.log_request(

3633:
3634: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3635: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3636: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3637: qp_delayed_requests_pvt.log_request(
3638: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3639: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3640: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3641: p_request_unique_key2 => NULL,

Line 3648: qp_delayed_requests_pvt.log_request(

3644: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3645: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3646: x_return_status => l_return_status);
3647: ELSE
3648: qp_delayed_requests_pvt.log_request(
3649: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3650: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3651: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3652: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,

Line 3672: qp_delayed_requests_pvt.log_request(

3668: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3669: p_QUALIFIERS_rec.list_line_id = -1 THEN
3670: -- header qualifier is added to price list/modifier
3671: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3672: qp_delayed_requests_pvt.log_request(
3673: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3674: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3675: p_request_unique_key1 => NULL,
3676: p_request_unique_key2 => 'I',

Line 3682: qp_delayed_requests_pvt.log_request(

3678: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3679: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3680: x_return_status => l_return_status);
3681: ELSE
3682: qp_delayed_requests_pvt.log_request(
3683: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3684: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3685: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3686: p_request_unique_key2 => 'I',

Line 3700: qp_delayed_requests_pvt.log_request(

3696: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3697: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3698: -- updated other than qualifier grouping number
3699: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3700: qp_delayed_requests_pvt.log_request(
3701: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3702: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3703: p_request_unique_key1 => NULL,
3704: p_request_unique_key2 => 'U',

Line 3710: qp_delayed_requests_pvt.log_request(

3706: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3707: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3708: x_return_status => l_return_status);
3709: ELSE
3710: qp_delayed_requests_pvt.log_request(
3711: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3712: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3713: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3714: p_request_unique_key2 => 'U',

Line 3724: qp_delayed_requests_pvt.log_request(

3720: ELSE
3721: -- qualifier grouping number is modified
3722: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3723: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1) THEN
3724: qp_delayed_requests_pvt.log_request(
3725: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3726: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3727: p_request_unique_key1 => NULL,
3728: p_request_unique_key2 => 'U',

Line 3734: qp_delayed_requests_pvt.log_request(

3730: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3731: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3732: x_return_status => l_return_status);
3733: ELSE
3734: qp_delayed_requests_pvt.log_request(
3735: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3736: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3737: p_request_unique_key1 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3738: p_request_unique_key2 => 'U',

Line 3743: qp_delayed_requests_pvt.log_request(

3739: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3740: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3741: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3742: x_return_status => l_return_status);
3743: qp_delayed_requests_pvt.log_request(
3744: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3745: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3746: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3747: p_request_unique_key2 => 'U',

Line 3759: qp_delayed_requests_pvt.log_request(

3755: END IF;
3756: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3757: p_QUALIFIERS_rec.list_line_id = -1 THEN
3758: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 then
3759: qp_delayed_requests_pvt.log_request(
3760: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3761: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3762: p_request_unique_key1 => NULL,
3763: p_request_unique_key2 => 'D',

Line 3769: qp_delayed_requests_pvt.log_request(

3765: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3766: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3767: x_return_status => l_return_status);
3768: ELSE
3769: qp_delayed_requests_pvt.log_request(
3770: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3771: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3772: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3773: p_request_unique_key2 => 'D',

Line 3784: qp_delayed_requests_pvt.log_request(

3780: -- line pattern
3781: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3782: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3783: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3784: qp_delayed_requests_pvt.log_request(
3785: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3786: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3787: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3788: p_request_unique_key2 => NULL,

Line 3795: qp_delayed_requests_pvt.log_request(

3791: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3792: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3793: x_return_status => l_return_status);
3794: ELSE
3795: qp_delayed_requests_pvt.log_request(
3796: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3797: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3798: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3799: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,

Line 3812: qp_delayed_requests_pvt.log_request(

3808: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3809: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3810: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3811: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3812: qp_delayed_requests_pvt.log_request(
3813: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3814: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3815: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3816: p_request_unique_key2 => NULL,

Line 3823: qp_delayed_requests_pvt.log_request(

3819: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3820: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3821: x_return_status => l_return_status);
3822: ELSE
3823: qp_delayed_requests_pvt.log_request(
3824: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3825: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3826: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3827: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,

Line 3837: qp_delayed_requests_pvt.log_request(

3833: END IF;
3834: ELSE
3835: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3836: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1) THEN
3837: qp_delayed_requests_pvt.log_request(
3838: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3839: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3840: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3841: p_request_unique_key2 => NULL,

Line 3848: qp_delayed_requests_pvt.log_request(

3844: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3845: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3846: x_return_status => l_return_status);
3847: ELSE
3848: qp_delayed_requests_pvt.log_request(
3849: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3850: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3851: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3852: p_request_unique_key2 => p_old_QUALIFIERS_rec.qualifier_grouping_no,

Line 3858: qp_delayed_requests_pvt.log_request(

3854: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3855: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3856: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3857: x_return_status => l_return_status);
3858: qp_delayed_requests_pvt.log_request(
3859: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3860: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3861: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3862: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,

Line 3875: qp_delayed_requests_pvt.log_request(

3871: END IF;
3872: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3873: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3874: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3875: qp_delayed_requests_pvt.log_request(
3876: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3877: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3878: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3879: p_request_unique_key2 => NULL,

Line 3886: qp_delayed_requests_pvt.log_request(

3882: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3883: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3884: x_return_status => l_return_status);
3885: ELSE
3886: qp_delayed_requests_pvt.log_request(
3887: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3888: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3889: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3890: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,